Hi All
I have a crosstab query that runs from a another query
The query runs a parameter asking for dates from/to
When I try to run the crosstab query I get a ms jet error message
What can I do
Thanks

Brendan Bartley

__________________
Brendan Bartley

What is the error message? What is theSQL in each query?

mmcdonal

I am getting the following error message
The Microsoft jet database does not recognize date as a valid field or expression
Thanks

Brendan Bartley

I just ran into this myself. I'm pretty sure you need to:

Open the query that your crosstab depends on.

Click "query", then parameters from the menu bar up top

In the window that opens, put your parameter name in there, and choose date/time as your data type. That should fix it.