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