Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

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

Status
Not open for further replies.
Sep 10, 2002
150
US
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!!!!
 
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
 
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 :)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top