James-
And more to the point, what day of the week is the payday, and what week of the
year does it start?
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-------------------------------------
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Clive
Sent: Monday, April 09, 2012 8:27 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: Pay Period Calculation (Access 2007)
Hi James,
Do you split the periods into calendar months or
blocks of 13 weeks?
What is your criteria for deciding the quarter that
the pay period within?
Regards, Clive.
--- In MS_Access_Professionals@yahoogroups.com, j1eggert <no_reply@...> wrote:
>
> Good afternoon,
>
> I am trying to create a query expression to calculate the number of pay
periods in a quarter (pay is bi-weekly). Each quarter may have either 6 or 7 pay
periods.
>
> I definitely need some guidance on this problem.
>
> Thanks in advance!
>
> v/r,
> James Eggert
>
Tidak ada komentar:
Posting Komentar