How to capture if Multiple columns are not blank?

[hellfire45]

Let's say I have three columns; apples, berries and bananas. I need to capture, either using the GUI or the SQL if any of those are not null, then bring that row back. So the rows that come back from the query are only ones where one of those three columns is not null.

In excel it would be if(or(apples<>"",berries<>"",bananas<>""),X,Y)



Thank you so much!

[June7]

Try criteria: Not Is Null

under each field but on separate lines so the OR operator is invoked.

3 fields for same type of data (fruit) sounds like non-normalized structure.