Criteria, DLookup, and IIF

  • Thread starter Thread starter croy
  • Start date Start date
C

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...
 
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...
Click to expand...

More data: all fields involved are Long Integer.
 
Back
Top