Thanks Jim! I tried replacing that 4 with a 1 since I know this combination to be true of at least one row but still nothing was selected. Overall, I am looking to select rows which have "yes" (coded as 1) as answers for at least 3 questions out of a group of 7 total questions (so >=3 total). Any tips would be greatly appreciated.
I suspect that Fruit_scanner and Vegitable_Scanner columns are numeric, not character. In your "Nonworking" example, you specified the comparison as:
If Fruit_Scanner is a numerical column the comparison would be:
Also look at the actual values of Fruit_scanner. I thought you indicated that the values were 0 or 1. If that is true then you need to be looking for:
The original reply that I published is the format that needs to be used to get what you want. What is needed are the actual names of the columns and the actual values in those columns. If you can provide that, I think I could give you the JSL