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
    Guest

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


Share This Page