Too Many Fields Defined

L

lucky33

I keep receiving the message "Too Many Fields Defined" when I try to
open a report. The query the report is running off gave me the same
message but I corrected that problem so now the query works fine.

Why does the report still give me the error message? If I remove
seven of my fields the report works fine but I do not have seven
fields that I can remove.

Any and all help is greatly appreciated.
 
D

Duane Hookom

This generally suggests an issue with your table structure. Most of us "old
guys" can't imagine a query/table with more than about 50 fields. If you
can't normalize or change your table structure, you might need to use
subreports.
 

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

"Fields Nested Too Deeply" Error in Simple Word Document 5
too many fields defined 8
Grouping Names in Mail Merge 0
Too Many Fields Defined Error 1
Too many fields defined 1
Access 2007 report to many fields 1
Too Many Fields Defined 2
too many fields for report 1

Top