sum in a report?

KeithB13

Registered User.
Local time
Today, 00:46
Joined
May 2, 2003
Messages
23
Hello all,

I have a list of serial numbers in a report. They are listed in rows of 6 per page and there are two pages worth. I would like to list the total number of objects on the list after the last serial number. I know the answer lies somewhere in the group footer, but I can't seem to get a handle on it.

Thanks for the help,
Keith
 
You could put this in the Group or report footer depending on whether you want to count the items in the group or whole report.

create a textbox with the controlsource set to

=Count([SerialNumberField])
 
More help?

I tried the code that was suggested. I inserted a text box into my report, I get "#error" where the total is supposed to appear. The control source is "=count([SN]). Running sum = "overall". Any ideas?

Keith
 

Users who are viewing this thread

Back
Top Bottom