queries- how to query data that meets a condition in FieldA OR another condition in FieldB

[analys919]

I want to run a query that gives results where EITHER
1.) field A is not blank (Is not null)
or
2.) field B is not blank

i know how to return results where BOTH conditions are true, but i do not know how to query so that all results are returned where one or the other criteria are true.

please help!

thanks

 

[Joe4]

Welcome to the Board!

I assume that you are entering these criteria in Query Builder (if you were writing it in SQL code directly, you would just use OR).

In order to get the OR instead of AND in Query Builder, simply put these two criteria in different criteria rows. When the criteria under multiple fields are on the same line, it is treated as AND. When they are on different lines, they are treated as OR.

 

[analys919]

joe-

thanks for the quick fix! works like a charm