If Statement - I think

[matthewR]

I have a query with a column "Product Category". The criteria for that field is "Two or More Products". I want that option for everything but there is one exception. I have another column that is "Health Drug Members". I want "Two or More products" unless "Health Drug Members" is not null then I want to get what is ever in that "Product Category" column. How would I do this?

[HansV]

Like this:

S263.jpg

[matthewR]

I was thinking it was harder than that. Thank you. I hope this is all they need to change.