I'm attempting to create a report showing the payment for examiners marking GCSE scripts and my gross pay field doesn't seem to be working.

The gross pay is merely the total number of scripts marked multiplied by the fee per script (which varies depending on subject).

The problem seems to be that because the total number of scipts is calculated by added the number of scripts each examiner marks at each school.

I can't see where I've gone wrong though.

Help would be much appreciated.

-------
"Lying is the most fun a girl can have without taking her clothes off...
...but it's better if we do."

"Kiss my black heart as the tears fall..."