D
Dennis
I'm using a crosstab query to keep track of employees who are tardy on a
daily basis. The times are tracked by the employee undocking and re-docking
his handheld computer from the docking station. At times the employee needs
to re-dock and pull the computer out again creating too logs of "out" times
in the table. I need to be able to capture the first record instead of the
second record.
My table is setup as follows
TblID ID Time Status Date
#### 009 6:58 a.m. OUT 06/14/08
#### 009 7:10 a.m. OUT 06/14/08
#### 009 3:32 p.m. IN 06/14/08
My crosstab query is setup to only show records that are from 7:01 a.m. and
up with a status of "OUT".
I need to have the second record ignored so that the employee doesn't get
charged for a tardy. Any help will be greatly appreciated.
daily basis. The times are tracked by the employee undocking and re-docking
his handheld computer from the docking station. At times the employee needs
to re-dock and pull the computer out again creating too logs of "out" times
in the table. I need to be able to capture the first record instead of the
second record.
My table is setup as follows
TblID ID Time Status Date
#### 009 6:58 a.m. OUT 06/14/08
#### 009 7:10 a.m. OUT 06/14/08
#### 009 3:32 p.m. IN 06/14/08
My crosstab query is setup to only show records that are from 7:01 a.m. and
up with a status of "OUT".
I need to have the second record ignored so that the employee doesn't get
charged for a tardy. Any help will be greatly appreciated.