Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2003
    Posts
    76

    Unanswered: Error Rate by Month

    Good day!

    I need to make a query for a report.
    The query needs to look like this: SEE IMAGE 1

    I have multiple tables that need to be included in this query. The table structure looks like this:
    SEE IMAGE 2
    And
    SEE IMAGE 3

    The query should seperate the items by month (ie. "1/*"), then it should look at the "GoodBad" field of all tables... add up the unchecked (0), then add the checked (-1) then divide the bad (unchecked/0) by the good (checked/-1) to get the error rate.

    Does this make sense?

  2. #2
    Join Date
    Jun 2003
    Posts
    76
    IMAGE 1
    Attached Thumbnails Attached Thumbnails errorbymonth.gif  

  3. #3
    Join Date
    Jun 2003
    Posts
    76
    IMAGE 2
    Attached Thumbnails Attached Thumbnails la.gif  

  4. #4
    Join Date
    Jun 2003
    Posts
    76
    IMAGE 3
    Attached Thumbnails Attached Thumbnails ltllp.gif  

Posting Permissions

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