Access 2007 report to many fields

[Kim T]

I need to make a report from wizard using a query that has 34 fields when I
get to the end of the wizard I get message "The wizard is unable to create
your form or report because you chose to many fields; please try again with
fewer fields" I need all the fields I tried using the report design but it
will only show tables I need the query for criteria questions I have. need
help

 

[Larry Linson]

I haven't done it with Access 2007, but have used various Report Wizards in
earlier versions to do the initial formatting of a report with more than 34
fields. The Wizards aren't promised to do everything you could possibly do
in Report Design View. You didn't say _what_ Wizard (and, since you are
using 2007, that wouldn't mean much to me, anyway), but perhaps you could
use the Wizard with enough fewer fields that it doesn't trip and fall over
its own feet, then go into Design View to modify and add more fields.

Larry Linson
Microsoft Office Access MVP