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
Click to expand...

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

summing 1
Summing and counting in Reports 4
Expression in reports with regards to columns 1
Summing main report and three sub reports 2
Trying to display query paramiters on the query based report 3
Foreign Currency on Reports 1
Summing Amount from Records with Yes checked off in Awarded field 3
Adding Totals on a report 2

Top