Create calculated fields: [2009 Salary]: [Salary]*[2008Increase]+[Salary]
Create calculated fields: Bonus: IIf([Performance]=”Excellent”,0.05*[Salary],IIf([Performance]=”Good”,0.025*[Salary],0))
Then create a new field called increase, tjem Subtract [2008 Salary] from [2009 Salary] to perform the