[AccessD] IIF statement - one more question

(IIf((DEPT In ("MSS","SW","OW") ),W_Date_Closed,[MID Advice Closed])) AS
NewDateClosed

one more question on IIF statemnts, the one above works fine however if i
try to add one more condition (and Disposition <> "REF MID") it ignores
everything where dsposition field is NULL. shouls i write something like
((DEPT In ("MSS","SW","OW") and Disposition <> "REF MID" or Disposition
isNULL) ?



(IIf((DEPT In ("MSS","SW","OW") and Disposition <> "REF
MID"),W_Date_Closed,[MID Advice Closed])) AS NewDateClosed




-----------------------------------------
Get Breaking News from CNN, ABC, NBC, CBS Now.
http://www.xuppa.com/news/?link=webmail