Hi there... i'm not sure how to do this...

I have a table which has

Emp_No,Emp_Job,TimeIN,TimeOut,DateIn,DateOut,Emp_SnE

as the fields. The form has two buttons, "Time In" & "Time Out", so when one is clicked, the other fields become null.

What i need to do now is create a new form with a button. when the button is clicked it has to search the old table for matching records and insert the merged records in a new table. This new table also has a new column called total time.


can anyone help?