Please can any one help me to change the follwing if statement into loop function or any Function that can summarize my Satement.

Field of EmpTable :

If EmpRank = "A1" then
EmpSalary = 1000 and EmpMealAllawance = 800 and EmpLeaveAllawance = 500
elseif EmpRank = "A2" then
EmpSalary = 1050 and EmpMealAllawance = 820 and EmpLeaveAllawance = 580
upto EmpRank "A15".
The EmpSalary, EmpMealAllawance and EmpLeaveAllawance have a differnces of Constant Value = 50, 20 and 80 respectively.
I just summarized the code.
And i am using MS Access 2016.