Recent content by haideeo

This is what I am not getting right. So I tried both of the following and still retrieved nothing: Like IIf(IsNull([Forms]![frmSearch]![BDR]),Like "*" Or [BDR] Is Null,"*" & [Forms]![frmSearch]![BDR] & "*") Like IIf(IsNull([Forms]![frmSearch]![BDR]),Like "*" Or IsNull([BDR]),"*" &...

I want to return all records

I am using a query by form to return results, but I am not able to retrieve the null values. I have tried a number of things: Without using the QBF the following query provides the results that I am expecting: Like "*" Or Is Null When I add this to my IIF query I get no results. My query is...