Crosstabs queries help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I enter date parameters for a crosstab query? I have used the where
date is between this and that expression in other queries however it will not
work in a this one.
 
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

Repeat for the other parameter

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
You must log in or register to reply here.

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

Parameter Queries in Crosstab Query 2
Duplicate prompts in crosstab query and subsequent report 1
crosstab query parameters for dates 1
crosstab parameterized query 1
Crosstab Query based on Query 4
crosstab query with parameter query 5
Parameter Value in Crosstab Query 4
Parameter query within a crosstab query 2

Back
Top