Recent content by Rainman

Peter 1. Bill 1. Etc Peter Bill Etc If Peter then (is null), (no change). If bill then (is null), (no change)

The combo is in a form. Uniform I use just is null in just one of the columns I get the correct result but the name is variable so I only want the column which relates to the name to show is null results. Really I just want to know how to write an iif statement using is null if true.

I select the name from a combo box then the query shows me which values are null against the name.

I just want to show null results in a column which matches up with a name. Column 1 data belongs to Peter, column 2 bill etc. So if Peter is selected I only see null values for him.

Thanks, but I just tried to simplify the example. I really want a number of columns I can filter using the criteria. Ie if it's Peter then see all the null results in column 1. If its bill then see all the null results in column 2 etc. Under each column in the criteria I wanted to write an iif...

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...