Access Does not recognize " as a valid field name or expression

M

MomO3

Hi,
I have a report that I've been running for months without a problem. All of
a sudden it receives the following message, "The Microsoft Access Database
Engine does not recognize " as a valid field name or expression." It's the
that lone " mark that has me stumped. The crosstab query the report is based
off runs without error every time. It's got one parameter defined as a
date/time field. There are no quote marks anywhere in my report. Oddly, I
used to be able to make the report run by going into design mode, bascially
doing nothing, then trying again. However, this work around is no longer
working. Does anyone have any ideas?

Many thanks!
Nancy
 
M

MomO3

Thanks Bill!

You got me thinking in the right direction. My report had referenced some
values in the crosstab query directly (yes, poor design). Those values had
changed, thus the illusion of a non-existent field.

Your help is very much appreciated!!!!
Nancy
 

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

Top