Sum on report

D

Dan @BCBS

Simple question - but driving me crazy.

I just want a sum on a report which is this:
=Sum([ClosePeriod])

But it returns a line for every record. I just want one line showing this sum.

suggestions?
 
D

Dennis

I suspect your line is in the detail section of the report. Put it in the
report footer section.
 

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

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Use TODAY() function as the criteria in a SUMIF formula 1
Autonumber field in Excel that behaves the same as Access 0
Report Group Footer DLookUp 0
Access Report Average Miles/Gallon in Group Footer and Report Footer? 9
Can't figure out what I'm doing wrong with running sum 2
Space at end of multi page list to accommodate new entries 1
Sum a field with null value 8

Top