Sum of fields in report

[Loony064]

Hey all

I've created a report to calculate the coinage to give employee's for their weekly wages. In the detail section of the report, i have the employee's name and nett wages, and then text boxes to store how many of each value of money he/she recieves (i.e. R200, R100, R50... - R = RSA Rand) I've calculated each breakdown using an if statement to prevent erros with null values) and then i basically divide by the monetary value, as follows:

=IIf([Nett_Wages]=0,0,[Nett_Wages]\200)

In order to calculate the second amount, i just take the modulation of the above amount and divide it by the next amount as follows:

=IIf([Nett_Wages] Mod 200=0,0,[Nett_Wages] Mod 200\100)

That works fine, but then at the end of the report, i want to calculate the total number of R200 notes i need, R100 notes i need, etc. I also wanted to calculate the total Nett Wages.

The total Nett wages was easy I just used

=Sum([Nett_Wages])

. I tried this method for the coinages, e.g.

=Sum([TxtTwoHun])

TxtTwoHun being the name of the first textbox, but when i run the report, it wants me to enter the number of TxtTwoHun, etc. Then i decided to instead do a running sum of all theTxtTwoHun overall, but it keeps just returning 0, which is incorrect for most cases.

I've attached a screenshot of the report for clarity.

Any help would be much appreciated
Laura