Too Many Fields Defined

[JimP]

A report query has more than 255 fields defined and is creating a "Too many
fields defined" error message.

One option is to split the report into (2) reports with separate queries.
Are there other work arounds?

 

[Duane Hookom]

IMHO, you first option would be normalization. If you don't understand, do a
google search on "data normalization".

I could be wrong so feel free to come back and explain why so many fields.

 

[John W. Vinson]

A report query has more than 255 fields defined and is creating a "Too many
fields defined" error message.

One option is to split the report into (2) reports with separate queries.
Are there other work arounds?

Two subreports on one (unbound) report, or... normalize if that's possible.