Is it possible to generate a report is add a bunch of number fields? 1

[mrtauntaun]

I have about 50 records (and growing) in a table that are strict number fields. I would like to generate a report, possibly based on a query, to add of of these fields up and give me a total. Can this be done? thanx!!!!

 

[PaulBricker]

This should be very easy to do in either a query or a Report. If you just want Totals in your Report, create a query with your Table, add all the fields you want, turn on the Totals by going to View...Totals on the Menu bar. Then on the Totals line select Sum for all the fields.

In the Report, if you want to see the Details, and then sum the Totals, you would add a Textbox, to the Report Footer, for each field you want to Total. The put this type of expression in the Control Source.
=Sum([FieldYouWantToTotal])

Paul

 

[mrtauntaun]

Thank you very much, I though it might have been a little trick I was missing. I am glad someone else besides me checks these on the weekend