J
Jim Moberg
Hi,
I'm trying to write a query that will calculate two different things: 1)
Amount of time an order is on hold. 2) Amount of time an order was in
process during weekends and holidays.
The first one is tricky because order statuses are stored in a separate log
table. Our data is stored something like this:
record number order number Status Status Date
1 abc123 In Process 2/2/2006 10:30 AM
2 abc123 On Hold 2/4/2006 10:30 AM
3 abc123 In Process 2/6/2006 9:30 AM
4 abc123 On Hold 2/7/2006 9:30 AM
5 abc123 In Process 2/8/2006 9:30 AM
So the total hold time would be 71 hours. How does one accomplish
calculating this in Access?
Then How does one calculate any time in process that may have been over a
holiday or weekend?
I'm trying to write a query that will calculate two different things: 1)
Amount of time an order is on hold. 2) Amount of time an order was in
process during weekends and holidays.
The first one is tricky because order statuses are stored in a separate log
table. Our data is stored something like this:
record number order number Status Status Date
1 abc123 In Process 2/2/2006 10:30 AM
2 abc123 On Hold 2/4/2006 10:30 AM
3 abc123 In Process 2/6/2006 9:30 AM
4 abc123 On Hold 2/7/2006 9:30 AM
5 abc123 In Process 2/8/2006 9:30 AM
So the total hold time would be 71 hours. How does one accomplish
calculating this in Access?
Then How does one calculate any time in process that may have been over a
holiday or weekend?