Is the criteria (in query designer) mutually independent

[accessaspire219]

Hi,
I have a query which is basically a data validation query for a list of item numbers. It looks into the master data table and has expressions in the columns with IIf statements to determine if any action needs to be taken. If an action needs to be taken it gives the action code in the cell.
It works fine up to this point.

Now as step towards exception management, I want it to show ONLY those rows where there is an action code. (obviously there may be a row with action code in one of the expression columns while the rest are null - this row should show up)

I tried to achieve this by specifying a criterion Is Not Null in the criteria part of query designer. However it doesnt seem to work since it returns no results when I do know there are some action codes in the query.

My question is:
1. Are the criteria that we specify in the query designer mutually independent? (as in if I have 4 columns with Is Not Null criteria will it interpret it as: show only if column 1 Is Not Null and column 2 Is Not Null and column 3 Is Not Null...and so on or will it interpret it as show if column1 Is Not Null Or Column 2 Is Not Null Or Column 3 Is Not Null...and so on)
I need it to be OR instead of AND - any suggestions how this could be done?
Thanks.

 

[boblarson]

If you want it to be OR then put each Is Not Null on a separate line. If they are on the same line as the others then it is treated as an "AND."

 

[accessaspire219]

I tried doing that, it still does not work. Atleast now I know for sure when it is treated as AND and when it is treated as OR. Will try again.