crosstab query parameters for dates

  • Thread starter Thread starter Renee
  • Start date Start date
R

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?
 
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)
 
Back
Top