I have a running sum on a report. What it does is add up points students at a school get each week.

http://adam.awoke.co.uk/Untitled-1.jpg

now the students get bronze award for reaching 75 points, silver for reaching 150, gold for reaching 250 and platinum for reaching 350 points. when they reach 350 points any additional points are carried over and the points start again. So say in week 6 a student has 320 points and they get 60 points that week, then at the end of the week they would recieve a platinum award and then the following week the points would be reset to 0 and they would have the excess 30 points after the platinum added on.

Now first of all i just want this to work for the points and then maybe also add and "award achieved" column to the right.

I have no idea how to achieve this as the running sum seems to be in the filed properties and doesn't seem to have much customable options. Any ideas?


Thanks

Adam

how about something like
if (runsumpoints> 100) then
txtbox.value=gold
end if
you would place this on the footer

ok, i kinda get this, BUT how would i insert this to the footer and make it relevant to the running sum property?

it is also really important (actually more important) that after reaching 350 it is set to 0 and the additional points carried