how to make IIf statement result show null value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a search form where there is a combo box for to choose the status.
(Open or Closed).

I want to make it where when user selects " Open", pulls up table result
wher column name " Status" shows everything but coded " Complete".

I used
IIf([forms]![form1]![status]="open",[credits]![status]<>"Complete",[credits]![status]="Complete")

however, if I choose " Open" in the form and search for it, it only shows
Status that is not coded " Complete " and not null value (the ones has not
been coded yet)

What is a proper IIf statment where if [Status] <> " Complete", then show
null value and also everything that is not coded " Complete"

Thank you!
 
I'd do 'iif (nz([status],"")="", empty or null,complete). 'is null' can also
be used in a query for just null. However Nz does it simpler. if status is
null it replaces it with an empty string.

HTH
Martin J
 
Back
Top