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
..
 
Back
Top