I have a report that I get information from a table. I want to be able to
add up all the entrys in the table and calculate a total. How do I do that?
The simplest way in a Report is to use the "View" menu option in
report design mode to view the Report's Footer. In that Footer section
you can create a textbox with a Control Source property of
=Sum([fieldname])
to sum the values shown on the report.
If you want to sum over groups of data (say, each "account" or each
"customer" or whatever), use the Report's Sorting and Grouping
property to create a group footer and put the Sum() expression textbox
on that footer.
John W. Vinson[MVP]
