Qnavry,

Would you mind posting your solution? I'm interested in seeing how you captured the PrevTotal using an update after the insert statement.

Thanks,

Lu.