how do I get Access to accept more fields in a report?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to build a large report in access and it tells me there are too
many fields. I'm working with 70 fields. Does anyone know a workaround?
 
Sounds like you are using the report wizard. The wizards have limits that
are less than the actual limits.

Try building your report with just some of the fields that you need. Once
you've done that you can go into the reports design view and add additional
controls. The easiest way to do that is to use the Fields window and drag
from there to the appropriate section of the report

Tip: Select View: Field List from the menu to see the list of fields
available for the report.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 

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

Can't create a report from my query in Access 1
What is the maximum number of fields allowed in an access report? 2
dynamic adaptive / variable report field format 1
Too Many Fields - Reports and Queries 9
Large Report with 70 fields 5
put more than 255 field on report from two tables 7
Expression in Access "Reports" 2
Filtering subreports on main report 0

Back
Top