Too Many Fields Defined Error

[petpil]

I have a database containing ten queries with many calculations in each
query. In each query I have a "total" field to total the calculations in each
query. I then have a central query which I use as my source for the report.
This central query includes the "total" fields from each of the ten queries.
When I run the report, I get "Too Many Fields Defined". When I run my
central query, everything works fine with no errors. I tried creating a new
report based on all of the fields in my central query. My central query
consists of 23 fields, 10 of which are the "total" fields from my 10 queries.
By just creating the report and not moving/manipulating anything, I get the
"Too Many Fields Defined" error. I have to remove between two and four of my
"total" query fields (depending on which ones I remove) in order to eliminate
the error which would lead me to believe that the error message is legit.
However, I don't understand why I can run my central query and not get an
error but I get this error when I try to create a report based on the central
query. Any suggestions on how to get around this problem?

 

[Tom Wickerath]

Hi Petpil,

Are you in the habit of regularly compacting your databases? If not, you
should be. The reason I ask is that there are two Microsoft KB (Knowledge
Base) articles that indicate compacting as a resolution, even though the
operation being performed is different:

"Too Many Fields Defined" Error Message Saving Table
http://support.microsoft.com/kb/198504

You receive a "Too Many Fields Defined" error message
when you save a table in Access 2002
http://support.microsoft.com/kb/291556


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________