Lextree Simply the best software for managing legal entities and documents.
The Berkman Letter Practical analysis and commentary for business, law, and more.

checking time value against an access table

0
stars
0
answers
6
views
my company has defined work hours (0730-1600) M-F, for our folks who travel, they can earn some OT when they fly. It must be after the end of the workday. So as an example, Employee A departs on Monday at noon to go to the airport and his/her flight departs at 16:50. Employee A is entitled to 1 hour of OT (round the 50 minutes). 
I have an MS Access table that stores has two columns and they are StartWD (0730) and EndWD (1600).  
i have an MS Access form for the employee to compute the overtime, my issue is how do I compare the date/time on the form against the table? 

I have no idea how to make this happen