Re: Getting hours worked from previous pay periods.

[Sam Spritzer <spritzer@LOCALNET.COM>]

Look for a table which contains all of the hours information and then you
can do a SELECT on that table with a WHERE clause of all hours that are
least than (or equal to the enrollment date.  If you just want 15 payperiods
or the 15th payperiod, you can use COUNT to get exactly what you want.  Hope
this helps.

Sam

At 08:29 AM 1/17/98 -0400, you wrote:
>Hi there:
>
>I want to create a procedure that would determine the hours worked by an
>employee x pay periods prior to enrollment in SDB. The enrollment date
>is known. What I need to determine is the hours worked let's say 15 pay
>periods prior to enrollment in Sick and Disability Benefits. Hope
>someone can help.
>
>Thanks.
>
>Aya.
>

spritzer@localnet.com
"This space perpetually under construction."