Sum in a report

G

Guest

Hi,

I have a report with some numeric values listed, but I need to make a sum of
them all and display it at the end.
How can I do that?

Thanks in advance.
 
A

Al Camp

David,
In the report footer, place an unbound text control eith a ControlSource
of
=Sum(YourNumericField1Name)
will give you a total for one field over the whole report.

Then, in the report footer you can add the sum of several fields.
Using another unbound text control with a ControlSource of...
=Sum(YourNumericField1Name) + Sum(YourNumericField2Name) etc...

hth
Al Camp
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Report Headers/Design 4
Access Report Average Miles/Gallon in Group Footer and Report Footer? 9
Report grouped totals not resetting. 2
Total in Access Reports 6
Can't figure out what I'm doing wrong with running sum 2
Summing a data field for the whole report 3
Calculating page/report sums using calculated data from subquery 6
Summing in a Report Footer 7

Top