Summing on Reports

E

Eric

Hello, I was wondering how I build a field that sums all of the data from a
certain field. For example, I have a field in each record with dollar
amounts and I just want the SUM on a report.

I'm assuming this is a fairly simple task... I just started working with
Access again, so I am a little rusty... if there is a good web-site to assist
with working with Access I would appreciate that as well.

Thanks
 
R

Rick Brandt

Hello, I was wondering how I build a field that sums all of the data
from a certain field. For example, I have a field in each record with
dollar amounts and I just want the SUM on a report.

I'm assuming this is a fairly simple task... I just started working with
Access again, so I am a little rusty... if there is a good web-site to
assist with working with Access I would appreciate that as well.

Thanks

In the ReportHeader or ReportFooter use a TextBox with a ControlSource
of...

=Sum(YourFieldName)
 

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


Top