Too Many Fields Defined!

[ajhts]

I have a medical service log report that is working great. I just added some additional totals at the bottom and it is telling me that I have too many fields defined when I am trying to run the report.

I am so close in being done with this whole project and I didn't expect this to be a problem. Can anyone help, is there a way around this? Let me know if I need to supply more information about this. Thank you!

AJ

 

[dhookom]

You may be able to add more controls or fields if you compact your database. Did you really have so many fields or controls? You can have up to 255 fields in a record source and over 600 controls on a form or report.

Often an issue like this suggests normalization problems.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.