Criteria with Crosstab queries

  • Thread starter Thread starter Robbie Doo
  • Start date Start date
R

Robbie Doo

Is it possible to use a Criteria with a Crosstab query the way we use for
regular queries, like - Between [startdate] And [enddate]?
 
Yes, it is.

First thing, with a crosstab query you MUST declare your parameters and if any
other queries are used in the crosstab their parameters must also be declared.

Open the query in design mode
Select Query: Parameters from the Menu
Fill in the EXACT name of the parameter in column 1
Select the data type of the parameter in column 2


John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
 
Thank you John

John Spencer said:
Yes, it is.

First thing, with a crosstab query you MUST declare your parameters and if any
other queries are used in the crosstab their parameters must also be declared.

Open the query in design mode
Select Query: Parameters from the Menu
Fill in the EXACT name of the parameter in column 1
Select the data type of the parameter in column 2


John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

Robbie said:
Is it possible to use a Criteria with a Crosstab query the way we use for
regular queries, like - Between [startdate] And [enddate]?
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date parameters won't work on crosstab report 1
Date Range on Crosstab Query to create a Reports 1
Report casues crash 4
Date criteria cause Crosstab report error 4
Crosstab Report Headings 5
Report and subreport w/Criteria Parameters issues 2
Pass-through query for sub report 1
Report doesn't show all records between dates 11

Back
Top