Report using Union Query

  • Thread starter Thread starter CINDY K
  • Start date Start date
C

CINDY K

When I run the query all fields show up just fine. When I
run the report, one field causes an error.
'Microsoft Access cannot find the field "Application".
Then it suggests I may have a mispelling or the field may
have been re-named or deleted. '

If I remove the field the report is correct and runs
fine. I am puzzeled because the query shows the field
with no problem. It is something between the report and
the query. I do not know how I can have a misspelling or
anything, because I am pulling the field off the drop down
list.

Any suggestions?
 
I am not sure, but generally I would avoid fieldnames that could be system
names.
I would never call a field just DATE, or NAME.
So you may try to rename the field from "Application" to something like
"ApplicNam"
 
Back
Top