Results 1 to 2 of 2

Thread: sumif function

  1. #1
    Join Date
    Apr 2004
    Location
    ny, ny
    Posts
    224

    Unanswered: sumif function

    I have the following table
    WO# ASSETNO DOWNTIME(hrs)
    1 0110 8
    2 1010 3
    3 0101 5
    4 0110 8
    5 1010 7


    How do I generate a report that displays each asset no and the total downtime associated with it ?

  2. #2
    Join Date
    Jun 2004
    Location
    Florida, US
    Posts
    521
    I assume here your table name is Table1 and follwing query will give you the result you want. then you can use this query to make your report.
    Code:
     
    SELECT Table1.ASSETNO, Sum(Table1.[DONWTIME(hrs)]) AS [DONWTIME(hrs)]
    FROM Table1
    GROUP BY Table1.ASSETNO;
    ghozy.

Posting Permissions

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