Looking for a means to total the values contained in a field.

A table contains a field called "Count". This field is formatted as
"Numeric". It contains a count of how many individuals will be in attendance
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/6620-looking-means-total-values-contained-field.html
for a booking. That table also has a date for each record, and some other
unimportant info...

What I am trying to obtain is a running total of that Count column. I have
generated a query that returns all the fields from the table. I would now
like to find a way to add each of the "Count" fields from all of the returned
records. This way I could later specify a date, and find out how many
individuals I would have in attendance on a given day.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6620

What is the best / easiest way to add field values from a group of records?
I will need to be able to display the results on Reports, as well as in
linked subforms.

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!