question

I have this table called "PAYROll", structured thus, Name Department Grade Level Step Basic Pay The Grade Level has a value of 1 to 17, while the Step has a value of 1 to 15 Each staff at the point of appointment is placed on a particular Grade Level and Step. Every Grade Level and Step has an designate amount as Basic monthly pay. Now i need a query that will make the Basic Monthly pay a function of the Grade Level and Step. Where Grade Level =1 and Step 1 then the basic monthly pay should be £200 or where GL is 1 and Step 2 then basic pay should be £250. We are looking at 255 possible outcome