In a query I have to apply the IIf function
I practically have to make the text appear
AABB for values from 10 to 21
CCCC for values from 21 to 40
DDDD for values from 41 to 50
EEEE for values from 51 to 60
FFFF for values from 61 to 70
I find myself in trouble because if I apply the code
IIf([field name]=11; "AABB";
n times for in single values from 10 to 51 ms access of says that the formula is too complex
Any ideas? Thank you