Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004

    Question Unanswered: Simple calculation query

    I'm new to using Access but have a query that has me stumped.

    I've created time fields in a report and a field that calculates the sum of the time fields.

    When doing a report I want to total all the calculated sum time fields and then average it out but no matter what I do it will not add up the total of all the calculated sum fields. I've tried queries to no avail.

    There's got to be a simple answer!

    Can you help?


  2. #2
    Join Date
    Sep 2003
    The extremely Royal borough of Kensington, London
    Select sum(V.SUM_AMT)
    (select sum(columnA) SUM_AMT
    from tableA
    group by columnB) V
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

Posting Permissions

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