Convert IF statement into Loop Function

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.

Crossposted at https://www.accessforums.net/showthread.php?t=83358 with replies and a solution