Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Looking For A Means To Total The Values Contained In A Field

Discussion in 'Information Technology' started by Trial & Error, Nov 4, 2005.

  1. Trial & Error

    Trial & Error
    Expand Collapse

    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.
  2. Loading...

Since you're here... we have a small favor to ask...     Become a Supporter      ::     Make a Contribution     

Share This Page