Crosstab Date Range criteria 1

[tj63069]

I have set up the qry that feeds the Crosstab qry with "Between ([StartDate]) And ([EndDate])" but get a message "Does not recognize [Start]"...How can I report by the date range??

 

[PHV]

Use the PARAMETERS statement in your SQL code, eg:
PARAMETER [StartDate]) DateTime, [EndDate] DateTime;
SELECT ...

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[dhookom]

IMO, faq701-6763.

Parameters are available in the query design at a location depending on your version of Access.

Duane
Hook'D on Access
MS Access MVP