Parameters

[pungigi]

Do Parameters work in a Crosstab Query?? I have a Crosstab that does exactly what I want it to do for ALL data, now I want to get specific, is there a way to do this??

 

[PHV]

Do Parameters work in a Crosstab Query
Yes, but you have to define them.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[pungigi]

Can you tell me where to find information on how to do this??

 

[PHV]

While in query design window, menu Query -> Parameters ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[dhookom]

While in query design window, menu Query -> Parameters ...

and then enter something like:
Forms!frmDates!txtStartDate Date/time
or
[Enter Start Date] Date/Time


Duane
MS Access MVP
[green]Ask a great question, get a great answer.[/green]
[red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]
[blue]Ask me about my grandson, get a grand answer.[/blue]

 

[pungigi]

Thanks!! This worked.

 

[pungigi]

Ok, I have a parameter assigned to a Crosstab Query as follows:

[Enter Begin Date]
[Enter End Date]
[Enter Plan Id]

For some reason it will ask me the above but no matter what I put it returns all information. Any ideas what I could be doing wrong???

 

[PHV]

Have you used the parameters as criterias ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[pungigi]

No

 

[PHV]

So, without criteria the standard behaviour is to return all information ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[pungigi]

So do I set up Parameters & Criteria?? I am sorry for sounding so stupid here but I am lost. Maybe this will help

QUERY
Vendor Name Vehicle Type ID Total of ID Trip Status
Group By Group By Count Count Where
Row Heading Column Hdg Value Row Heading

In("S1","SQ")

 

[PHV]

For the date field choose where and in criteria: Between [Enter Begin Date] And [Enter End Date]
For the Plan ID field choose where and in criteria: =[Enter Plan Id]


Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[pungigi]

When I do as you suggest, I get the following error box

The Microsoft Jet Database engine does not recognize "[Begin Date]" as a vaild field name or expression.

Also, Do I get rid of the Parameter I have assigned to the Query??

 

[PHV]

Do I get rid of the Parameter I have assigned to the Query
No, you have to use it as criteria with the exact same spelling.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[pungigi]

WORKED, Thanks a bunch for being patient with me.