Good Day! I would like to ask for any idea on how to record the time log using recordset. Can you please give me some ideas on how to do it?

BTW im using vb 6.0 and access03 for my sources.
my fields are EmployeeNo. EmployeeName. TimeIn. TimeOut. TimeIn(2). TimeOut(2)

For time(2) that include breaktime.

I used DataEnvironment before but i think that's not good enough. So please help me.

Thankyou in advance!!

When I wrote a time clock application many, many moons ago, I used multiple tables in the database and just kept the time stamps.

Basically something along the lines of this:

Employee Table

EmpID Employee PunchStatus

PunchID EmpID PunchTime

Then I would use a query to piece the data back together.