I'm trying to calculate vacation hours earned in a query. This is what I came up with, but it will not accept it.
VacEarned: iif(YearsOn<2,"8", iif(YearsOn>=2 and <5,"9"), iif(YearsOn>=5 and <,"10"), iif(YearsOn>=10 and <15,"11", iif(YearsOn>=15 and <20,"13"), iif(YearsOn>=20 and <25,"15"), iif(YearsOn>=25 and <30,"17"), iif(YearsOn>=30 and <35,"21")
I get this error: