Tom, I understand what you are saying, but, that being the case why did the
"$10" calc not display "1" (rounding $8.73 up to "$10" first)?

"Tom Lake" wrote:


"akelogorian" wrote in message ...
Can anybody help?
I have been upgrading an old payroll system in Access now that we have
Office 2007. The original system that I inherited calculated the Notes and
coin requirements with manual input for each employee, a long and tedious
job. I have attempted to "automate" this task by using the "\" function in
the Build window, and have the following results:
Using as an example a Nett Pay of $178.73,
$50: [Nett Weekly Pay]\50, returns 3 -$150.00
$20: ([Nett Weekly Pay]-([$50]*50))\20, returns 1- $20.00
$10: (([Nett Weekly Pay]-([$50]*50)-([$20]*20))\10), returns 0
$5: (([Nett Weekly Pay]-([$50]*50)-([$20]*20)-([$10]*10))\5), returns 1 -
$5.00
Balance at this stage is $3.73
$2: (([Nett Weekly Pay]-([$50]*50)-([$20]*20)-([$10]*10)-([$5]*5))\2),

(178.73 - 150 - 20 - 5)

returns 2, when it should be 1.

Any ideas? I would appreciate an answer.

Here's what the help file says (emphasis mine)
Before division is performed, the numeric expressions are rounded to Byte, Integer, or Long expressions.

Since 3.73 is ROUNDED, it goes up to 4 before the integer division. 4 \ 2 = 2



Tom Lake