waay too many fields in a report

A

Andy

I am trying to make a report based on a query that has 90
fields (yes, 90). When I put all of it into the wizard,
it tells me that, "The wizard is unable to create your
form or report becuase you chose too many fields; please
try again with fewer fields."

Is the only solution to this to make the report manually?
What is the upper limit to the number of fields that the
wizard can handle?
 
T

Tony Vrolyk

make a temporary copy of your 90 field query and nock it down to 10-20
fields. Use the Report wizard based on the temp query and get the basic
layout done. Then change the record source of the report to your 90 field
query and add the other 80 fields as needed.

Chances are that the qizard wouldn't put 90 fields where you want them
anyway, so this is not much more work.
 

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

Access 2007 report to many fields 1
Too many fields in Report? 2
too many fields for report 1
Create a Tabular Report with more than 30 fields 1
Report Update Fields 0
too many fields defined 8
Too Many Fields - Reports and Queries 9
Can't create a report from my query in Access 1

Top