Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2012

    Red face Unanswered: Selecting multiple rows with different values

    I have a table with serial numbers (SN) and remaining life (RL). A single serial number may have multiple rows with different values for RL. Can I group the serial numbers and report only when all of the values of RL for any given SN are 0?

    Example -
    SN 123: RL 5
    SN 123: RL 2
    SN 246: RL 0
    SN 246: RL 3
    SN 468: RL 0
    SN 468: RL 0

    Can you write a query that gives me only SN 468 as a valid answer since all of it's RL values are 0?

  2. #2
    Join Date
    Apr 2005
    Zagreb - Croatia
    Look at "DemoRL0A2000.mdb" (attachment, zip).
    Look at Table1, Query1. Run query.
    I think it is what you need.
    Attached Files Attached Files

Posting Permissions

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