Senin, 09 April 2012

[MS_AccessPros] Re: Pay Period Calculation (Access 2007)

 

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