S
Sabosis
Hello-
I have a query which will indicate any employee on an active write up
in the last six months. What I need to do, based on the example below,
is to use each employees WU date as the "start date" for their
individual record in a new query. The number that is represented in
the LateStarts is the number since they started employment. I want to
know the number of Late starts since the WUDate to see if they need to
move on to another write up. I dont know how to use the WUDate field
as a starting point for each person though. Please advise if you can
help. Thanks
EmplID Last Name Late Starts WUDate
150 Jones 1 9/5/2008
193 Harris 20 7/15/2008
154 Williams 42 11/17/2008
196 Flores 2 7/10/2008
204 Hansen 8 11/14/2008
177 Walters 30 10/30/2008
I have a query which will indicate any employee on an active write up
in the last six months. What I need to do, based on the example below,
is to use each employees WU date as the "start date" for their
individual record in a new query. The number that is represented in
the LateStarts is the number since they started employment. I want to
know the number of Late starts since the WUDate to see if they need to
move on to another write up. I dont know how to use the WUDate field
as a starting point for each person though. Please advise if you can
help. Thanks
EmplID Last Name Late Starts WUDate
150 Jones 1 9/5/2008
193 Harris 20 7/15/2008
154 Williams 42 11/17/2008
196 Flores 2 7/10/2008
204 Hansen 8 11/14/2008
177 Walters 30 10/30/2008