Tracking employees time in access

J

Jennifer P

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????
 
V

Vince

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
 
Top