Calculating fields in Access 2010
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