"Too Many Fields Defined" for Report

[JohnG316]

I have a report that brings together 4 tables of data to
create individual company reports, but I've exceeded the
255 limit. How would you recommend creating the reports
so that I can generate this as a single report run? Would
subreports work? Each company has a unique ID that is
used to grab the appropriate data from each separate table.

Thanks in advance.

 

[JohnG316]

es, it is the query itself that is being exceeded and I'm
trying to pull all the data elements together and am not
sure the best way to accomplish this.

 

[Larry Linson]

"JohnG316" wrote

Yes, it is the query itself that
is being exceeded and I'm
trying to pull all the data ele-
ments together and am not
sure the best way to
accomplish this.

Subreports are your best bet, as each has its own query and each query can
have up to 255 fields.

Here's a heads-up, though. A report with more than 255 distinct items of
information is going to be difficult to use by a mere human. Thus, you
should prepare yourself to deal with usability problems when you _do_ print
out all that information.

Good luck.

Larry Linson
Microsoft Access MVP