I have a field called DaysOpen. I want to run a query that will result in a Description field based on the following. If the DaysOpen is < 30 days, I want the query result for the field to say "<30 Days" and if the query of the expression of the field is 30-60 days, I want the expression to return the description "30-60 Days". And, if the DaysOpen is greater than 60 days, I want the descriptive text to say ">60 Days".
So, basically, when I run the query the Description field must come back with 1 of 3 results..."Less than 30 Days", "30-60 Days", or ">60 Days".
I am pretty sure I use the IIF statement, but can't seem to get it right to come back with the results.