IIF Statement Help

[mclem]

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.

[June7]

Should really show attempted code.

DaysOpen is a number value?

Something like:

IIf(DaysOpen < 30, "<30 Days", IIf(DaysOpen<=60, "30-60 Days", ">60 Days))

or

Switch(DaysOpen <30, "<30 Days, DaysOpen <=60, "30-60Days", True, ">60 Days")

[Bob Fitz]

Try:
IIf([YourFieldName]="< 30 days","Less than 30",IIf([YourFieldName]="30-60 days","30-60 Days","> 60 Days"))