if statement

[sirlosi]

I need help writing an if statement in a query for a category field that has multiple values. I am looking for an equation that will look at the category field and return L if the category is (LB, NF, WC, TFA, TFU, or TSU) if not return value in category field.

[jzwp11]

You will need to use the IIF() function if I understand correctly what you are trying to do. The query may look something like this. You will have to substitute your own table and field names

SELECT Table5.pkRecID, IIF(Table5.category in ("LB","NF","WC", "TFA","TFU" ,"TSU"),"L", Table5.category)
FROM Table5;

[ssanfu]

<snip>
SELECT Table5.pkRecID, IIF(Table5.category in ("LB","NF","WC", "TFA","TFU" ,"TSU"),"L", Table5.category)
FROM Table5;

I think you will also have to name the calculated field:

SELECT Table5.pkRecID, IIF(Table5.category in ("LB","NF","WC", "TFA","TFU" ,"TSU"),"L", Table5.category) AS FIELD1 FROM Table5;

Of course, change "FIELD1" to what you want the field named.

[sirlosi]

Works great. Thanks for the help.

[jzwp11]

You're welcome. Glad we were able to help.