Update Query

[smith]

I have a form that is used for data entry into a table. The form has two fields on it, call them EmpNum, and Timenow.

When the form gets data, from a barcode scanner, for example, the two fields are entered into a table. The employee number and the time his id number was read by the bar code scanner.

But the table has an additional field on it, for designating whether a swipe was a "Clock in" or a "Clock out". I would like an update query to add these values to the table.

Table has 4 fields - pk#, EmpNum, Timenow, Scantype

If I could run a query and first group the records by EmpNum, then order the records returned by the query into EVEN or ODD numbers, then the ODD numbered records would be "Clock In" and the EVEN numbered records would be "Clock Out" records.

Then I could use a regular query to calculate hours worked on a project for example.

I tried creating an update query, but I am not successfully finding the right function or parameter to get what I want.



Can anyone help?

[June7]

Could try this criteria in WHERE clause (assumes no gaps in pk sequence):

[pk#] Mod 2 = 0
or
[pk#] Mod 2 <> 0

BTW, special characters, spaces, punctuation (underscore is exception) in names is not advised. Better would be pkNum.