I am about to undertake the use of calculated controls on reports. Oddly enough, I have never had the need for this information in any database I have ever created. Well, now I do. I HAVE been reading the help files and will continue to do so. All I would like to ask is for replies as to things I should AVOID when using these controls.

Thank you in advance.

You will have some difficulty summing them, if you have a great many or the calculations are complex you may get an out of memory message, in which case you'll have to create sub queries, but the general consensus is to put calculated controls directly onto forms or reports. You should be O.K.

Thank you Rich. I don't know how many records the database will eventually hold so I should take your advice now and sum my records in "ranges" and then do the averaging I will need later. This will eliminate the need for the complex calculations I believe you are speaking of. Thanks again.