Hi, Nono.
My suggestion is you redesign your table structure.
For example:
PersonID(Number)
Salary(Currency)
CommissionFirst(Currency)
CommissionSecond(Currency), etc
I think Access would always return the amount "3000"+"xxx"(that you input in the second or third row and so on, because Access recognize the second/third commissions belong to another record(in your case another PersonID and another Salary)
Well, hope this would help you.
Herru
|