I have a field that will always be 0 or 1. How do I create a query where the IF statement is IF any fields are showing as 1, ELSE if there are no fields with a value of 1. So, if there was at least 1 field with the value as 1 it would show all fields with that value, and if they all had value of 0 it would show something else entirely. Does that make sense?

Thanks
Russ