Seperate records

  • Thread starter Thread starter to5150c
  • Start date Start date
T

to5150c

I have built a timeclock for my employees in Access. I can put the time
clocked in in the field, but when I open the form to clock them out they get
seperated as 2 different records. Is there any way to fix this and make them
1 record.
ex.
TIME IN TIME OUT
employee a 0800
employee a 0900
 
Hi

Create a Table
tblEmployees
in the table put
EmplyeeID - Autonumber
Employee1stName
Employee2ndName
plus other employee details

Create another table
TblTimes
TimeID
EmplyeeID - number - link this with the TblEmployees
Date - Time/Date format
TimeIn - Time/Date format
TimeOut - Time/Date format

Create a form based on TblEmplyees
Single form format
Put the ID - Name etc

Create a query based on TblTimes
Put the TimeID EmployeeID Date TimeIn Time Out
Plus a calculated comlumn like this
BeenAtWork: DateDiff("n",[TimeIn],[TimeOut])\60 & ":" &
DateDiff("n",[TimeIn],[TimeOut]) Mod 60

Create a continous form based on this query

Open the form based on TblEmployees in design view

Open the tool box
Select Subform
Select you Times form and click somewhere on the form where there is a nice
space

Save and View

Good luck



Continous format
 
Back
Top