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

  • Thread starter Thread starter MomO3
  • Start date Start date
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
 
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
 
Back
Top