Hi,
I have the following Query titled "State_Product".
The query looks like the following:
State Product1 Product2 Product3
NY Yes Yes Yes
IL NO Yes NO
FL Maybe NO Yes
GA NO NO NO
KY Maybe Maybe Maybe
I want to create another column - "Status". If columns - Product1, Product2 and Product3 all are matching then it is "OK" otherwise "Not OK". In example above, KY, NY and GA will be "OK" while IL and FL will show "Not OK". How do I do this?