Experts Exchange is the only resource I have found that has a solution to my problem in it;'s archive of several years ago.
I am developing a DB that tracks fleet vehicle maintenance. The vehcile will be placed OOS(Out Of Serverce) fro the duration of their maintenance. Data entry will be In Date/times (InDT) and Out Date/Time (OutDT) I need to break a time line into 1 hour blocks and count the status odf all vehehicle in the 1 hour block.
Grayl has already solved the issue from a previous thread several years ago for another OP. I trying to fllow his solution and have changed code, but I am not getting any output, though no errors. I'm sure it is something very basic like inputting a date field, but I've tried in several places and have no joy.
Link To Grayl's solution is here:
My adaptation of Grayl's code:
TRANSFORM Count(qryCmbDate.Status) AS CountOfStatus
FROM tbl_Hours, qryCmbDate
om,0,0)) Between DateAdd("n",-Minute([InDT]
),[InDT]) And DateAdd("n",-Minute([OutDT
)) And ((qryCmbDate.OutDT) Is Not Null))
GROUP BY TimeSerial([tbl_Hours].[Hr
Attached is my sample query in TEST3_Exchange
In my research I have not come across anything like what Grayl has written, so it is quite a learning curve.
The Anticipated result is the following:
Date Hour Count
5/10/2014 9:00 1
5/10/2014 10:00 1
5/10/2014 11:00 1
5/10/2014 12:00 2
5/10/2014 13:00 2
5/10/2014 14:00 2
5/10/2014 15:00 3
5/10/2014 16:00 3
5/10/2014 17:00 3
Attached is the DB. I hope you can help with a bit of a deconstruc of the code. Am I able to contact Grayl and alert him to this problem that he would be familiar with?