# Calculated Total with beginning Value

1. Novice
Windows 7 64bit Access 2010 64bit
Join Date
Jan 2012
Location
East Texas
Posts
16

## Calculated Total with beginning Value

Hi, I have a database to keep track of bus drivers' points. For any negative actions, they have points taken away, for any positive, they have points added (I wish this would work for my kids...).

But now, instead of just coming to a maximum of 30 points before letting that driver go, HR wants it to be more positive.

Total: IIf([TotalPointsForOffense]>0,IIf([TotalPointsGiven]>0,[TotalPointsForOffense]-[TotalPointsGiven],[TotalPointsForOffense]),[TotalPointsGiven])

This added up all the offense points and subtracted out the given points.

I changed that to:
Total: IIf([TotalPointsForOffense]>0,IIf([TotalPointsGiven]>0,[TotalPointsGiven]-[TotalPointsForOffense],[TotalPointsForOffense]),[TotalPointsGiven])

So now the negative is subtracted from the total with the positives added.

My dilemma is that we need to start from 95. For example, a driver has 95 points and had a wreck which removed 20 points, ending in 75 points.

Is there a way to modify the last expression with a beginning quantity?

Thank you,
Michelle