Query too many fields

M

mark r

What is the limit to the number of fields pulled by a
query from several tables using join?

I am getting an error that my QUERY (that will feed my
report) has too many fields defined, it seems to be
topping off around 250........so how do you feed a report
(via a query which pulls from several tables)with 300 data
elements/ controls? (even up to the limit which I am told
is 754 controls per report)
 
J

John Vinson

What is the limit to the number of fields pulled by a
query from several tables using join?
255.

I am getting an error that my QUERY (that will feed my
report) has too many fields defined, it seems to be
topping off around 250........so how do you feed a report
(via a query which pulls from several tables)with 300 data
elements/ controls? (even up to the limit which I am told
is 754 controls per report)
Click to expand...

I'd suggest a Report with Subreports.
 
Top