Adam,
I find it hard to understand:
- how you created over 400 fields in a query when I thought the maximum was 255
- why you have more than about 40 fields. A properly normalized table typically has less than 40 fields
- what business need requires so many fields
Are you using Access tables? Do you have control over the table structures?
At times a compact and repair will allow creation of more controls on a report. I expect subreports would work and serve to mask table structure issues.
Duane Hookom MVP
MS Access
To: MS_Access_Professionals@yahoogroups.com
From: runuphillracing@yahoo.com
Date: Tue, 25 Mar 2014 08:46:09 -0700
Subject: [MS_AccessPros] Too many fields defined
I'm creating a report in 2007. Record Source is a query with a lot of fields in it. When I add a text field and start entering the Control Source, I get that error message. It does allow me to enter the source after clearing the message. Do I get that message because there are too many fields (400+) in the query? If so, suggestions on how to make this work? Break the query up into several, and break the report into several too (presumably one main with several sub reports)?
Thanks
Adam
Denver, CO
I find it hard to understand:
- how you created over 400 fields in a query when I thought the maximum was 255
- why you have more than about 40 fields. A properly normalized table typically has less than 40 fields
- what business need requires so many fields
Are you using Access tables? Do you have control over the table structures?
At times a compact and repair will allow creation of more controls on a report. I expect subreports would work and serve to mask table structure issues.
Duane Hookom MVP
MS Access
To: MS_Access_Professionals@yahoogroups.com
From: runuphillracing@yahoo.com
Date: Tue, 25 Mar 2014 08:46:09 -0700
Subject: [MS_AccessPros] Too many fields defined
I'm creating a report in 2007. Record Source is a query with a lot of fields in it. When I add a text field and start entering the Control Source, I get that error message. It does allow me to enter the source after clearing the message. Do I get that message because there are too many fields (400+) in the query? If so, suggestions on how to make this work? Break the query up into several, and break the report into several too (presumably one main with several sub reports)?
Thanks
Adam
Denver, CO
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar