Report with non-existing fields in underlying query

  • Thread starter Thread starter Rinius
  • Start date Start date
R

Rinius

Hi,
I have a report with 100 fields, like this: [Field1],
[Field2]..[Field100]
Underlying query of this report has only several fields
like this: [Field2], [Field5], [Field70]
I get an error message: "The Microsoft Jet database engine
does not recognize [Field1] as a valid field name or
expression"
How can i avoid this error message? I think Nz() function
does not work in this case.
Thanks for help
 
Rinius said:
I have a report with 100 fields, like this: [Field1],
[Field2]..[Field100]
Underlying query of this report has only several fields
like this: [Field2], [Field5], [Field70]
I get an error message: "The Microsoft Jet database engine
does not recognize [Field1] as a valid field name or
expression"
How can i avoid this error message? I think Nz() function
does not work in this case.
Click to expand...

The error message is inevitable when you do that, you can
not tell the report there are fields in the query when the
fields don't exist.

If you could explain what you're trying to accomplish, maybe
someone will be able to suggest a way to do it.
 
Back
Top