I want the field "[Commission Dept CummPerc]" to return a cumulative percent by grabbing the previous record (when "Temp Dept" = the previous "Temp Dept" field.
Unfortunately it is not working properly and the "Temp CumCommission" field is not bringing in not cummulating the commssion in the "Temp CumCommission" field it is only bringing in the current records Commission. Botto line for some reason it is not performing the rangesum as part of the if statement but I can't figure out why.
Thanks for trying to help Karl. I changed my script to match what you send and it didn't change anything. What is frustraitng is I had it working for a while and then all of a sudden it wasn't. It retur ns values that are based on the current rrow - nothing is accumulating.