How to put a sum at the end of data?

M

Min

Hi, I want to know, at the end of listed data, I need a sum to show total,
The data shoould be:
No. Data
1 3
2 5
3 2
Sum 10

How to do this in a report?

Thanks!
 
A

AlCamp

Min,
If [Data] ia a bound field, a text control in the Report Footer with a
ControlSource of...
=Sum([Data])
will give you a total for the whole report.

Also, in any Group Footer, it will yield the total for that Group.

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

Top