adrianscotter
Registered old fart!
- Local time
- Today, 23:12
- Joined
- Jul 7, 2014
- Messages
- 124
Hey guys
I'm stuck and have been for several hours now trying to get this to work :banghead: I need to get a percentage figure for the success rate of collections. Certain items must be collected within a time window that can be from 1 hour to 8 hours. For a monthly report, they would like to know what percentage of bags were collected in the time window allocated. I have a date range (the report is by month). The bag collection data stored is 'From Time' and 'To Time' plus the 'Actual Time' collected. At the moment, I must have a dozen queries and a 'Google history' that has about 400 entries trying to nail this but I have had no success. Anyone give me a pointer before I crack open a bottle of scotch
I'm stuck and have been for several hours now trying to get this to work :banghead: I need to get a percentage figure for the success rate of collections. Certain items must be collected within a time window that can be from 1 hour to 8 hours. For a monthly report, they would like to know what percentage of bags were collected in the time window allocated. I have a date range (the report is by month). The bag collection data stored is 'From Time' and 'To Time' plus the 'Actual Time' collected. At the moment, I must have a dozen queries and a 'Google history' that has about 400 entries trying to nail this but I have had no success. Anyone give me a pointer before I crack open a bottle of scotch