Yes, I agree with you and Duane. All other approaches I researched on-line were complicated and inflexible.
--- In MS_Access_Professionals@yahoogroups.com, "Bill Mosca" <wrmosca@...> wrote:
>
> 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