Use parameters with crosstab query ???

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
 
B

Beetle

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

crosstab parameterized query 1
Multiple Parameter Crosstab query filter by form 1
crosstab query parameters for dates 1
Duplicate prompts in crosstab query and subsequent report 1
too complex query 5
USING PARAMETERS IN A CROSSTAB QUERY 4
Crosstab query problems 11
Query using date range entered by user 2

Top