Too Many Fields Defined

J

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?
 
D

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.
 
J

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?
Click to expand...
Two subreports on one (unbound) report, or... normalize if that's possible.
 
Top