IIf Statment with Is Not Null not working 1

[hartwell]

Hi Guy's

Could anyone shed any light on why this would not work? If I put in a string which i know exsits replacing "Is not null" it works but is not null just wont work...

If the PC username = Hartwei then bring back everything which isnt null else bring back my record only

IIf(Environ("Username")="hartwei",Is Not Null,Environ("Username"))

 

[r937]

could you please show the entire query? go to SQL View and paste what you have here

r937.com | rudy.ca

 

[hartwell]

SELECT tblUsers.RACFID
FROM tblUsers
WHERE (((tblUsers.RACFID)=IIf(Environ("Username")="hartwei",(tblUsers.RACFID) Is Not Null,Environ("Username"))));

 

[Golom]

WHERE IIf(Environ("Username") = "hartwei",
          tblUsers.RACFID Is Not Null,
          tblUsers.RACFID=Environ("Username")

 

[r937]

SELECT RACFID
FROM tblUsers
WHERE RACFID = IIf(Environ("Username")="hartwei"
,RACFID,Environ("Username"))

r937.com | rudy.ca

 

[hartwell]

Cheers, worked like a dream!