Report with non-existing fields in underlying query

[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

 

[Marshall Barton]

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.

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.