Field Error

G

Guest

When I try to create a report on an existing query, I get the following error:

The wizard is unable to create your form or report because you chose too
many fields; please try again with fewer fields.

Can someone help me get around this?
 
A

AlCamp

Jason,
Ditch the wizard, and Create a new report manually. Go to Reports and
just select NEW.
In the RecordSource property for the report, enter the name of the query
you built.
Now those fields from the query can be placed on the form. A query...
and thus a report, can have a max of 255 fields. The wizard can't handle
that many.
hth
Al Camp
 

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
Create a Tabular Report with more than 30 fields 1
Can't create a report from my query in Access 1
waay too many fields in a report 1
Too many fields in Report? 2
too many fields for report 1
too many fields defined 8
What is the maximum number of fields allowed in an access report? 2

Top