Tracking employees time in access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to see if someone can help me write the code in a form to auto
calculate to fields. I know that this is just duplicating a field in a query
or report but the boss wants it....

I have two fields

[BeginTime] and [EndTime] they are formatted as general time 04/01/05, 12:00
My Boss wants to look at the form view and see it automatically calculate
the time. I have one shift that starts at 22:00 and goes till 07:00 so this
is why he wanted the date. Any suggestions????
 
Not sure exactly what you are wanting to do, but if you are just wanting to
calculate the numbers of hours the following will work. Put it as a
calculated field in a query.

TimeElapsed: DateDiff("h",[start time],[end time])

Hope it helps.
Vince
 
Back
Top