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),
returns 2, when it should be 1.

Any ideas? I would appreciate an answer.