Running Totals

Hello! I need to define a field that is a bit of a summary field, but also one that gets calculations performed with each record added.

I am trying to do a field that gives available hours of vacation after each pay period. The users enter the hours used, and they accrue vacation time at a flat rate per hour worked.

So I'm wanting to have:

Total Hours accrued +

Hours accrued this period -

Vacation used this period

where

Total Hours accrued = Hours earned prior to this pay period

Hours accrued this period = hours eligible to earn vacation * flat rate

Vacation used this period = hours entered by user as having taken for vac.

I tried using a summary field (running total) but that is impacted by how I sort the records. I would like to have the values static, regardless of how it is sorted. Any help would be GREATLY appreciated as this would REALLY make timecard automation a lot easier for the people using it.

Paul Erickson