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