Crosstab query

[Guest]

I have a crosstab query which includes a date criteria (ex 4/30/07). The
query works when a single date crtiteria is used.

However, when I update the criteria to include a parameter date range (ex
1/31/07 - 4/30/07) I receive the following error message: " The MS Jet
database engine does not recognize '[Enter Start Date]' as a valid field name
or expression".

The criteria line of the query has: >=[Enter Start Date] AND <=[Enter End
Date] to allow the user to enter any date range.

How can I get this to work?

 

[John Spencer]

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 any other parameters.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..