Criteria, DLookup, and IIF

[croy]

I'm trying to get this to work:


IIf(DLookUp("District","tblDistrictStart")=4,Null,(DLookUp("District","tblDistrictStart")))

The goal is, if the value for the field looked up is 4, then
use no criteria. But if the value is something else, then
use it for the criteria.

Any suggestions are appreciated...

 

[croy]

I'm trying to get this query criteria to work:


IIf(DLookUp("District","tblDistrictStart")=4,Null,(DLookUp("District","tblDistrictStart")))

The goal is, if the value for the field looked up is 4, then
use no criteria. But if the value is something else, then
use it for the criteria.

Any suggestions are appreciated...

More data: all fields involved are Long Integer.