Access 2000 Date/Time Problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table that holds production data. Data from employee production
logs is keyed into a form that feeds this table. The employee production log
has a Function Field (what function the processor is performing), Processing
Date, a Start Time, and an End Time.

I need to determine the "Wait Time" between functions by calculating the
difference between the end time for function "A" and the start time for
function "B". My problem is that sometimes the end of a function falls on
the following day and the processors only enter the Processing date on their
production logs. (The data entry person enters start & end times on the form
in military time).

Is there a way to calculate the wait times with the information that I have
without having the data entry person key an end date?

Thank you in advance for your help.
 
I forgot an important point. Each function is on a different row in the
table so I need to know how to calculate on fields in different rows.
 
Back
Top