Hours of service

  • Thread starter Thread starter jjpittman via AccessMonster.com
  • Start date Start date
J

jjpittman via AccessMonster.com

I really need help to calculate hours that are available to drive. A
driver can drive a total of 70 hrs in 8 days. I am having difficulty trying
to get this accomplished. Within 8 days a driver is off for a day the hours
would reset to 0 and the day counter would reset as well. Here is a sample
of the SQL table.


SELECT tblDriverTime.[DriverID], tblDriverTime.Date, tblDriverTime.Regular,
tblDriverTime.Overtime, tblDriverTime.[Total Time]
FROM tblDriverTime;
 
So what are the field types?
DriverID - Text field?
Date - Date field storing only the date (no time component)
Regular - a number field containing number of hours
Etc.

Is there only one record per day per driver at a maximum?

If the driver doesn't drive on a specific day, is there a record? If so
what is in the record to tell you the driver did not drive.

Given those details someone might be able to start on solution for you. I'm
not sure I can see all the pieces of a solution.
 
DriverID - Text field?
(text )
Date - Date field storing only the date
(no time
component) (date (shortdate not time)
Regular - Overtime, Total Time
(are all
double)

Is there only one record per day per driver at a maximum?
(one record
for the day)

If the driver doesn't drive on a specific day, is there a record? If so
what is in the record to tell you the driver did not drive.
(Currently
there are no records for a driver that did not drive)

Given those details someone might be able to start on solution for you. I'm
not sure I can see all the pieces of a solution.
I really need help to calculate hours that are available to drive. A
driver can drive a total of 70 hrs in 8 days. I am having difficulty trying
to get this accomplished. Within 8 days a driver is off for a day the hours
would reset to 0 and the day counter would reset as well. Here is a sample
of the SQL table.

SELECT tblDriverTime.[DriverID], tblDriverTime.Date, tblDriverTime.Regular,
tblDriverTime.Overtime, tblDriverTime.[Total Time]
FROM tblDriverTime;
Click to expand...
 
Back
Top