Time Period

  • Thread starter Thread starter sonta
  • Start date Start date
S

sonta

Access 2000.
I have four fields in tbl Main.
A (Date/Time - format is medium time )
B (text)
C (Date / Time)
D (memo)

A form contains these fields. I would like a user to enter the fields where
some indicator measures the time taken for the operator to get through one
record.
ie. the difference in time taken from when the user enter field A until he
exits out of field C.
Would I have to introduce a text box the work out the time difference
between fields A and C ?
or create a new field called Time Difference.
Note: the time starts from the point in which the user enters field A with
mouse and the time finishes for that record when user exits (having entered
a date) field C.
thanks for any help.
 
Don't create a new field: calculated values like this shouldn't be stored in
the database.

Rather, create a query, and add a computed field to the query. Use the
DateDiff function to calculate the time difference. Use your query wherever
you would otherwise have used the table.
 
Back
Top