Wildcard * not showing Null entries

[CharlieT302]

Hi Folks,

I am using a wildcard in an IIF statement for a query criteria. It works fine but will not display Null entries.

Here is the criteria:
Like IIf([forms]![frm Assessment Pending Filter].[allSup]=0,[forms]![frm Assessment Pending Filter].[SupSelect],"*")

How can this be modified to show "All" and "Null" entries if [allsup]=0(see the "*" at the very end of the statement)

Thanks

 

[PWise]

Add this to the SQL statment for string field

Where nz(FieldName,"")= IIf([forms]![frm Assessment Pending Filter].[allSup]=0,[forms]![frm Assessment Pending Filter].[SupSelect],nz(FieldName,""))

this for numric field

Where nz(FieldName,0)= IIf([forms]![frm Assessment Pending Filter].[allSup]=0,[forms]![frm Assessment Pending Filter].[SupSelect],nz(FieldName,0))

 

[PHV]

In the criteria cell:
=[forms]![frm Assessment Pending Filter]![SupSelect] OR [forms]![frm Assessment Pending Filter]![allSup]=0

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886