Search results
-
R
Help with IIf and is null
Hi, I'm sure this is straight forward but can't seem to solve it. I am trying to create in the query a criteria to say IIf [a condition is true] then return IS NULL, if false then do nothing. I tried this but it doesn't work IIf([Test]![Name]="Peter",Is Null,) Can anyone help ? Thanks...