Re: How can i pass a parameter to crosstab query

From: megeorge (megeorge_at_discussions.microsoft.com)
Date: 01/13/05 

Date: Wed, 12 Jan 2005 18:43:01 -0800

Thank you very much. Sorry for being so thick.

"Rick Brandt" wrote:

> megeorge wrote:
> > John, Thanks for responding. No I understood Duanes response. I have
> > the parameters declared as you all have instructed. When I run the
> > query it prompts me for the value for the parameter. for example one
> > of the parameters is for a forecast id. I want the user to first
> > select a valid forecast id from a drop down list on a form. then use
> > that value in the parameter for the cross tab query.
>
> No, you still don't understand. You seem to be making the assumption that a
> "parameter" in a query is something that prompts you for input when the query is
> run and you want to eliminate that and use a form reference instead. What the
> previous responders have been attempting to make you understand is that a form
> reference is also a parameter (just a different kind).
>
> In the following query...
>
> SELECT * FROM SomeTable
> WHERE SomeField = Forms!SomeForm!SomeControl
>
> ....the string "Forms!SomeForm!SomeControl" is considered a parameter. It is
> just not a self-prompting parameter like what you are thinking of. Most queries
> in Access will use such a parameter without you having to explicitly go into the
> parameters dialog of the query and make an entry. The parameter is just
> resolved on the fly.
>
> A crosstab query is a bit more stubborn and insists that all parameters be
> explicitly listed in the parameters dialog. So if I wanted to use the above
> form reference in a crosstab query I would have to open the parameters list and
> enter "Forms!SomeForm!SomeControl" as a parameter and indicate the DataType.
>
>
> --
> I don't check the Email account attached
> to this message. Send instead to...
> RBrandt at Hunter dot com
>
>
>

Relevant Pages

  • Re: Dynamic Cluster Security
    ... Shweta wrote: ... > Thanks for responding to my query! ... > The details of network are: I will have four linux boxes, ... > To this query of mine someone had responded saying either SSH or Ipsec ...
    (comp.os.linux.security)
  • Re: Dynamic Cluster Security
    ... Shweta wrote: ... > Thanks for responding to my query! ... > The details of network are: I will have four linux boxes, ... > To this query of mine someone had responded saying either SSH or Ipsec ...
    (comp.security.ssh)
  • Re: sql update script
    ... Thank you for helping me out again (Albert thank you again for responding in ... Yet the script looks so much like simulair scripts I saw on the discgroup. ... Creating a query that includes a calculated field to do that, ... "Albert D.Kallal" wrote: ...
    (microsoft.public.access.formscoding)
  • Re: How can i pass a parameter to crosstab query
    ... > John, Thanks for responding. ... > query it prompts me for the value for the parameter. ... run and you want to eliminate that and use a form reference instead. ... A crosstab query is a bit more stubborn and insists that all parameters be ...
    (microsoft.public.access.queries)
  • Re: How can i pass a parameter to crosstab query
    ... this was all very helpful but how does the query know which field in the ... >> John, Thanks for responding. ... > run and you want to eliminate that and use a form reference instead. ... > A crosstab query is a bit more stubborn and insists that all parameters be ...
    (microsoft.public.access.queries)
Loading