Too many Fields Defined

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a challenge with one aggregate report that keeps claiming that I have too many fields. The query it is based on has 150 Fields (it is a questionaire measuring responses at three times in the year). It does contain many IIF statements. I have performed the compact and repair utility several times. Any suggestions to save this without having to break this report up? Thanks for your help

Dan
 
When a report has been modified extensively over a period of time, you can
encounter a limit.

This limit of about 700 controls is NOT reset with a compact.

So, simply highlight the report, and do a save as to the same database with
a temp name. Delete the original, and then re-name the one copy you just
made. You will now eliminate the message that you have too many fields...
 
Back
Top