crosstab query parameters for dates

[Renee]

I have a crosstab query where column headings are dates and rows are names. I
want to query the crosstab query to show a specific range of dates, so I set
up my parameters on the criteria line to be a start date and an end date
(Between [start date] And [end date]), but when I run the query, I keep
getting this message that says "The Microsoft Office Access databse engine
does not recognize '[start date]' as a valid field name or expression." Any
suggestions?

 

[Douglas J. Steele]

Especially with crosstab queries, it's important to declare your parameters
and their types.

In front on your current SQL statement, add

PARAMETERS [start date] DATETIME [end date] DATETIME;

(don't forget to include the semi-colon at the end of that)