Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Apr 2001
    Thanked 0 Times in 0 Posts

    Calculate a sum (XP)

    I would like to sum the values of one field in a query and display that one total in the report. Is that possible?

  2. #2
    3 Star Lounger
    Join Date
    Aug 2001
    Darkest Kent, UK., Kent, England
    Thanked 0 Times in 0 Posts

    Re: Calculate a sum (XP)

    Sure you can.

    Create the query and click on the toolbar button that looks like an 'E' (says Totals when you hover the mouse over it).
    This will add an extra line to the query grid allowing you to group your data by field and to get totals for suitable values. Try it with your existing data and see what the different settings can do.

    Save this query, then create an report based on it. Using the Auto-Report wizard is a good idea.

    Have a look at the new report in design view and you'll see how it's been put together.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts