I tried to add this field to my query but didn't work. I also tried to use switch but the result is the same. I tried using dlookup and created another table for the values but when i run the query, the fields are repeated by the number of fields in the new table!
can anyone help please!
IIf([GrossPay] Between 4000 And 4999.99,50),
IIf([GrossPay] Between 5000 And 5999.99,62.5),
IIf([GrossPay] Between 6000 And 6999.99,75),
IIf([GrossPay] Between 7000 And 7999.99,87.5),
IIf([GrossPay] Between 8000 And 8999.99,100),
IIf([GrossPay] Between 9000 And 9999.99,112.5),
IIf([GrossPay] Between 10000 And 10999.125),
IIf([GrossPay] Between 11000 And 11999.99,137.5),
IIf([GrossPay] Between 12000 And 12999.99,150),
IIf([GrossPay] Between 13000 And 13999.99,162.5),
IIf([GrossPay] Between 14000 And 14999.99,175),
IIf([GrossPay] Between 15000 And 15999.99,187.5),
IIf([GrossPay] Between 16000 And 16999.99,200),
IIf([GrossPay] Between 17000 And 17999.99,212.5),
IIf([GrossPay] Between 18000 And 18999.99,225),
IIf([GrossPay] Between 19000 And 19999.99,237.5),
IIf([GrossPay] Between 20000 And 20999.99,250),
IIf([GrossPay] Between 21000 And 21999.99,262.5),
IIf([GrossPay] Between 22000 And 22999.99,275),
IIf([GrossPay] Between 23000 And 23999.99,287.5),
IIf([GrossPay] Between 24000 And 24999.99,300),
IIf([GrossPay] Between 25000 And 25999.99,312.5),
IIf([GrossPay] Between 26000 And 26999.99,325),
IIf([GrossPay] Between 27000 And 27999.99,337.5),
IIf([GrossPay] Between 28000 And 28999.99,350),
IIf([GrossPay] Between 29000 And 29999.99,362.5),
IIf([GrossPay] >=30000,375)))))))))))))))))))))