IIf or an alternative function.

[diakis]

In a table with 5000 records there is a field named "products" with 800 differents products (product1, product2, … product800).
I want to create a new field in a query and mark 100 of these products as "Not available" and the rest 700 as "Available".
For a small number of products I can do this in QBA, using IIf function.
E.g. Products not available:IIf([products] ="product5";"Not available"; IIf([products] ="product10";"Not available"; IIf([products] ="product22";"Not available";"Available"))).
How can I do this for 100 products
Thank you.

 

[ajetrumpet]

E.g. Products not available:IIf([products] ="product5";"Not available"; IIf([products] ="product10";"Not available"; IIf([products] ="product22";"Not available";"Available"))).
How can I do this for 100 products

Just wondering if these 100 products have anything in common at all. Any similarities from which you can identify them from the rest?

 

[diakis]

No they have not anything in common. I think that Pat Hartman answer is o.k.
Thank you.