waay too many fields in a report

[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?

 

[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.