Date/Time update

[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.

 

[Stockwell43]

Hi Christine,

See if this helps:

http://office.microsoft.com/en-us/access/HA011102181033.aspx

 

[John W. Vinson]

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.

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.