Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2011
    Posts
    413

    Unanswered: Sorry to ask this?

    Is there a way to get sums in a select query?

    I have problems when I try to use a crosstab so this is my dilemna.

    I have a field in my query named Hours, how can I get the sum of this?

  2. #2
    Join Date
    Sep 2006
    Location
    Surrey, UK
    Posts
    994
    Provided Answers: 2
    Code:
    SELECT Sum([Hours]) AS SumOfHours
    This usually works! Of course, it depends on the data type of the field in question. If it's set to Date/Time, you might see unexpected results as Access stores time as a decimal fraction of a day.
    10% of magic is knowing something that no-one else does. The rest is misdirection.

Posting Permissions

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