In the 8 years I've been maintaining a financial reporting database, I've see the fiscal year change from 13 4-week periods to 12 monthly periods. The fiscal year start has changed twice. Pay periods have gone from semi-monthly to every 2 weeks and back again.
Therefore my Payroll table has:
FiscalYear
FiscalPeriod
FiscalPeriodStartDate
FiscalPeriodEndDate
FirstPayDate (of the period)
I've written code to fill it for each new fiscal year. The thing is too stay flexible as Duane implied.
Regards,
Bill Mosca, Founder - MS_Access_Professionals
http://www.thatlldoit.com
Microsoft Office Access MVP
https://mvp.support.microsoft.com/profile/Bill.Mosca
--- In MS_Access_Professionals@yahoogroups.com, "Duane" <duanehookom@...> wrote:
>
> I expect that pay periods can and do often change as businesses change. This suggests creating a table of payperiods with the dates. This should allow quick and accurate querying of the counts by year, month, ququarter, or whatever.
>
> Duane Hookom
> MS Access MVP
>
> --- 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