Date/Time update

  • Thread starter Thread starter ChristieB
  • Start date Start date
C

ChristieB

How do I create a field that will update a time if two other fields are the
beginning time and the end time? I need the total hours that elapsed between
those two times to be automatically updated in my table.
 
How do I create a field that will update a time if two other fields are the
beginning time and the end time? I need the total hours that elapsed between
those two times to be automatically updated in my table.
Click to expand...

The time between the start and end time should NOT be stored in any table.
It's redundant.

Instead, you can use a Query or the control source in a form or control
textbox; use a calculated field such as

=DateDiff("h", [BeginningTime], [EndTime])

to calculate integer hours, or

=DateDiff("n", [BeginningTime], [EndTime])/60

to get hours and fractions of an hour.
 
Back
Top