Thedda
Registered User.
- Local time
- Today, 00:46
- Joined
- Aug 2, 2002
- Messages
- 16
I have a database that counts how many work orders have been completed by date. Here is an example of the data.
Work Order - Date Complete -Qty Complete - Work Order Qty
20001 - 9/2/09 - 5 - 50
20001 - 9/3/09 - 25 - 50
20001 - 9/4/09 - 15 - 50
20001 - 9/5/09 - 5 - 50
20002 - 9/2/09 - 50 - 75
20002 - 9/3/09 - 25 - 75
What I need to know is the date the orders completed at >=85% of total work orders. For example work order 20001 would have completed 85% on 9/4/09. I appreciate any help you can give me on this.

Work Order - Date Complete -Qty Complete - Work Order Qty
20001 - 9/2/09 - 5 - 50
20001 - 9/3/09 - 25 - 50
20001 - 9/4/09 - 15 - 50
20001 - 9/5/09 - 5 - 50
20002 - 9/2/09 - 50 - 75
20002 - 9/3/09 - 25 - 75
What I need to know is the date the orders completed at >=85% of total work orders. For example work order 20001 would have completed 85% on 9/4/09. I appreciate any help you can give me on this.
