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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Some mail merge fields not pulling into document 2
Too Many Fields Defined Error 1
Too Many Fields Defined 2
Help needed passing data from the form to a table. 0
Default value on continuous form from query 2
Too Many Fields - Reports and Queries 9
Crosstab query 2
Using a Parameter Query in a Report? 2

Top