Access Report not recognizing " as valid field

M

Molly

After creating a report with wizard using a longer date
range I get this message when I try to shorten the date
range. "The Microsoft Jet database engine does not
recognize " as a valid field name or expression." I
assume it has something to do with some fields not
appearing with the shortened date ranges. How can I fix
this.
 
D

Duane Hookom

Either lengthen your date range or provide a bunch more information so that
we can help you.
 
J

John Vinson

After creating a report with wizard using a longer date
range I get this message when I try to shorten the date
range. "The Microsoft Jet database engine does not
recognize " as a valid field name or expression." I
assume it has something to do with some fields not
appearing with the shortened date ranges. How can I fix
this.
Click to expand...

Please post the SQL of your query. Just what do you mean by "a
shortened date range"?
 

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 query with parameter query 5
Error when using criteria to prompt for input 4
crosstab query parameters for dates 1
USING PARAMETERS IN A CROSSTAB QUERY 4
Microsoft Jet database engine does not recognize... 2
Crosstab query error 1
Crosstab query... 2
Crosstab query 1

Top