Use parameters with crosstab query ???

  • Thread starter Thread starter mscertified
  • Start date Start date
M

mscertified

I need a crosstab query and I need it to be parameterized. However whenever I
insert the parameters I get an error message. When I remove them, the query
works. e.g.
WHERE ReviewDate >= [StartDate] AND ReviewDate <= [EndDate] FAILS
WHERE ReviewDate >= $10/1/2008# AND ReviewDate <= #10/31/2008# WORKS
 
Crosstab queries are rather picky about parameters in the criteria
row for some reason. Open the query in design view and go to
Query/Parameters and enter your parameters, along with the
Date/Time data type, in the parameters window. See if that works.
 
Back
Top