Calculating A Time Period

  • Thread starter Thread starter MValentine
  • Start date Start date
M

MValentine

I am using Access in Office 2000.I have created a database
with 3 time oriented fields: Arrival Time, Departure Time
and Total Work Time. I would like to have the Total Work
Time automatically calculated when the operator enters the
Arrival and Departure Times. I have used Date/Time and the
Medium Time format for defining the fields. Any
suggestions?

Thanks
 
You can't do this in a table. Access tables are not like spreadsheets.
However, you can do it in a query. Using the Query Builder grid, in a blank
column, put this: Total Work: [Departure Time] - [Arrival Time]. You can
set the format in the properties of the new column.
 
Roger
Thanks for your response. This helped tremendously

-----Original Message-----
You can't do this in a table. Access tables are not like spreadsheets.
However, you can do it in a query. Using the Query Builder grid, in a blank
column, put this: Total Work: [Departure Time] - [Arrival Time]. You can
set the format in the properties of the new column.

--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org

MValentine said:
I am using Access in Office 2000.I have created a database
with 3 time oriented fields: Arrival Time, Departure Time
and Total Work Time. I would like to have the Total Work
Time automatically calculated when the operator enters the
Arrival and Departure Times. I have used Date/Time and the
Medium Time format for defining the fields. Any
suggestions?

Thanks
Click to expand...


.
Click to expand...
 
Back
Top