1 1 3
Using the Criteria line on the query builder, lets say I have two columns X and Y
- I need to see ALL of the records where X is Blank
-PLUS ONLY the records where X is Not Blank AND Y Is not Blank
- from the above example I would only see row 2 and 3
So I have tried (under Column Y): Like IIF(Isnull([X],"*",Not Is Null)