Change Record value to another field

[JPaulo]

Hi all;

I have a table with 2000 records.
I need to put the last hour of the day and employee for the field EndTime.
It is possible for vba cod?

Look at the picture in attached, please.

 

[vbaInet]

There's nothing that indicates which record is Start or Finish.

Have a look at this thread:

http://www.access-programmers.co.uk/forums/showthread.php?t=202757

 

[JPaulo]

Thanks for responding VbaInet.

Friend, in field exist the one time lower and one higher
which corresponds to the entry and departure from the employee, I need to separate by date and employee
and insert in another table (for example).

 

[vbaInet]

So an employee does not clock in more than once in a day? And it can never happen?

 

[JPaulo]

Yes VbaInet , never.
Only has one input and one output.

 

[vbaInet]

Okay, it shouldn't be too hard. Here are the steps:

1. Add the three fields to your query.
2. The alias for EndTime will be:

EndTime: (SELECT Q.StartTime FROM TableName WHERE Q.EmployeeID = TableName.EmployeeID AND Q.[Date] = TableName.[Date] AND Q.StartTime > TableName.StartTime)

3. Finally, put NOT IS NULL under this alias, EndTime criteria.

NB: Change TableName to be the table you're using. Remember you shouldn't be using Date as a field name because it is a reserved keyword. If you continue like this you must enclose Date in square brackets (like I've done).

 

[JPaulo]

Perfect, worked a charm

The word Date and Time are not being used, just in example.

Thanks and Merry Christmas

 

[vbaInet]

Merry Christmas to you to!