I have to make a correction to the information provided. Pay periods are based on Calendar year and not fiscal year. The first paycheck was received this year, January 12th. All employees receive their checks on Thursday, biweekly.
--- In MS_Access_Professionals@yahoogroups.com, John Viescas <JohnV@...> wrote:
>
> 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