Results 1 to 3 of 3

Thread: chart issue

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

    Unanswered: chart issue

    I have a query that gives me the asset no and the total downtime associated with each. I need a way to filter that to the top ten highest downtimes.

    Thank you

  2. #2
    Join Date
    Apr 2004
    Location
    ny, ny
    Posts
    224
    this is what i have so far which doesnt work

    SELECT WorkOrders.AssetNo, Sum(WorkOrders.Downtime) AS total, Count(WorkOrders.AssetNo) AS [No]
    FROM WorkOrders
    WHERE (((WorkOrders.DateReceived) Between Forms!SelectDateDowntime!BeginningDate And Forms!SelectDateDowntime!EndingDate))
    GROUP BY WorkOrders.AssetNo
    ORDER BY Sum(WorkOrders.Downtime) DESC;

  3. #3
    Join Date
    Apr 2004
    Location
    metro Detroit
    Posts
    634
    sort the query desc by downtime

    go into the query's properties and enter 10 for Top Values

Posting Permissions

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