Date parameters and crosstab queries

[carpstar]

I created a crosstab query to be used to generate a report. If I include the date field in the query as is it runs fine, but when I try to use parameters for date, just a simple "Between [start date] And [end date]" without the quotes. The query returns error that jet engine doesn't recognize [start]. What is the proper way to get date parameter to work with crosstab query. Do I need to make a create a table query with only the dates I need for the crosstab then create the crosstab from that table?
Please help, if someone could shed some light on this, would be most appreciated.
Thanks to all...
Rory

 

[Rich]

Either add the Date field again and set the criteria on that field or define the parameters StartDate Date/Time

 

[carpstar]

Rich, Are you saying to add the date field again in the query or the table, because I have removed and re-added the date field a number of times in the query to no avail.
Can you clarify your second suggestion " define the parameters StartDate Date/Time" where/how to do this.
Again thanks

 

[carpstar]

I'm still hoping for some additional help with this problem, hopefully someone can explain to me how to make this work.

As always thanks

 

[Pat Hartman]

Crosstab queries are not as flexible as other types of queries. When you use parameters in them, the parameters need to be specifically declared. Open the query in design view and select parameters from the properties dialog. Make sure to enter the parameter names EXACTLY as they are in the query and to define their data types correctly.