T
Tara
I'm working on a query which calculates a paycheck witholding amount. I take
the employees desired yearly contribution and divide it by the number of
paychecks in a year, in our case, that's 26. This gives me the amount that
needs to be witheld from each paycheck, provided the employee in question was
employeed at the first of the year. Depending on how I write the expression
in the query, I get 2 different numbers. Examples of the field expression in
question follow:
Bi-Weekly: ([curContrib]/[Weeks])
This gives me the wrong result, even if Weeks = 26.
Bi-Weekly: ([curContrib]/26)
This gives me the correct result.
Because employees who start after the first of the year will not have 26
pays that year, I need to be able to calculate the result based on the number
of checks they will actually receive, not 26. That's where the calculated
field Weeks comes in. I need to use that rather than a standard number of
26. Why the different results??
Thanks!
the employees desired yearly contribution and divide it by the number of
paychecks in a year, in our case, that's 26. This gives me the amount that
needs to be witheld from each paycheck, provided the employee in question was
employeed at the first of the year. Depending on how I write the expression
in the query, I get 2 different numbers. Examples of the field expression in
question follow:
Bi-Weekly: ([curContrib]/[Weeks])
This gives me the wrong result, even if Weeks = 26.
Bi-Weekly: ([curContrib]/26)
This gives me the correct result.
Because employees who start after the first of the year will not have 26
pays that year, I need to be able to calculate the result based on the number
of checks they will actually receive, not 26. That's where the calculated
field Weeks comes in. I need to use that rather than a standard number of
26. Why the different results??
Thanks!