What are the maximum number of access fields allowed in a report?

  • Thread starter Thread starter Guest
  • Start date Start date
1) feel free to use the large expanse of space below the subject line to ask
your question
2) reports don't have fields, they have controls. Tables and queries have
fields
3) you can find this information and much more in Help by searching on
Specifications
 
Well I'll put it this way, I have a report that contains 32 fields from 2
different tables combined. To create the report, I had to manually make it
(the report wizard could not handle the amount of fields).

P.S Don't just post a question in the subject header. Details like
below are helpful:
1) What you are trying to do is beneficial to getting an
answer.
2) How many fields you are trying to use?
3) what version of access you are using
4) in some cases what level of user/designer you are.

If you give little or nothing, you get little or nothing.
_Bigred
 
_Bigred said:
Well I'll put it this way, I have a report that contains 32 fields from 2
different tables combined. To create the report, I had to manually make it
(the report wizard could not handle the amount of fields).
Click to expand...

When you select multiple tables in the report wizard you are in effect creating
a multitable query for the report's RecordSource. The maximum number of fields
in a query is 255.

The maximum number of controls in a report (including sections) is 754 over the
lifetime of the report.
 
Back
Top