Max # of fields in an access report

[Guest]

I am linking an excel file to a database file and need to generate an access
report from the data. Using the wizzard it is telling me that I have
selected too many fields. what is the maximum # fields that can be used and
how do I find it?

Thanks

 

[Rick B]

go to help and type "specification" then click on the one pertaining to
reports.

 

[Arvin Meyer]

754 controls (that includes labels) in the LIFETIME of a form or report.
Since Excel allow 255 columns, you will be safe if you don't add and delete
them multiple times. If that's the case, just build a new report.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Brendan Reynolds]

I don't remember the exact figure, but I believe it's between seven and
eight hundred. I think the wizard may have a limitation that is much lower
than that, though. You'll probably be fine if you don't use the wizard but
build the report manually.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.