Field Error

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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
 
Back
Top