T
Trial & Error
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
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.
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.
"Numeric". It contains a count of how many individuals will be in attendance
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.
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.