Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2005
    Posts
    55

    Unanswered: Adding or generating the sum

    Hi!

    I have created a microsoft access database that deals with the amount of leave an individual takes.

    I want to be able to add up the amount of leave a person takes eg. John Mark takes a day on May 19th 06 and he takes 2 days from May 24th -25th 06 and take on in June 8th 06. These days are entered in different time period.

    I have fields where I entered the amount of days taken, it looks like this

    NAME DAY AMOUNT

    John Mark May 19th 06 1
    John Mark May 24th -25th 06 2
    John Mark June 8th 06 1

    So I want to be able to get the total amout of leave taken by John Mark how do I go about doing this?

    Thanks for the help!

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Code:
    SELECT Name, Sum(Amount) AS TotDays
    FROM MyTable
    Group By Name
    Testimonial:
    pootle flump
    ur codings are working excelent.

Posting Permissions

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