AutoCount

I need a way to auto advance the number for each instance of a value.





Continuous Subform Named FEmpBonus



BonID PK

EmpID FK



Payment Currency

NoOfPaymnts Number



Need to Add a number into field NoOfPaymnts for each Amount.

Amount = $50.00 NoOfPaymnts = 1

Amount = $40.00 NoOfPaymnts = 2

etc... Default is Null

AutoCount