I have written a crosstab query asking for a date criteria of Between [1st Date] and [Last Date]. When I try to run the query, I receive an error message refering to the Jet engine not recognising the [1st date]. However, the query does work if I enter between #01/08/2001# and #31/08/2001#.
I would like the user to be prompted to enter the required date period, How do I do this?

In design view, right click in the window where tables and relationships are represented. Choose Parameters in the menu. You will then be prompted to indicate the parameters names (give them explicit names) and data types.

Now, my 2 cents is that in some cases it is better to first make a select query gathering data and selecting them according to criteria / parameters. Then throw them into a cross tab query. It might be more efficient if you have a lot ofdata to process, and on some complex examples I happened to get different results when trying to select data on criteria directly from the crosstab.

Alex