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:
Like IIf(IsNull([Forms]![frmSearch]![BDR]),Like "*" Or Is Null,"*" & [Forms]![frmSearch]![BDR] & "*")
If I remove the null portion of my query I get all of the BDRs that are populated, which is part of the way to the results I would like to see:
Like IIf(IsNull([Forms]![frmSearch]![BDR]),"*","*" & [Forms]![frmSearch]![BDR] & "*")
What is the proper syntax to retrieve the BDRs that are populated as well as the null values?
Thank you for your assistance.
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:
Like IIf(IsNull([Forms]![frmSearch]![BDR]),Like "*" Or Is Null,"*" & [Forms]![frmSearch]![BDR] & "*")
If I remove the null portion of my query I get all of the BDRs that are populated, which is part of the way to the results I would like to see:
Like IIf(IsNull([Forms]![frmSearch]![BDR]),"*","*" & [Forms]![frmSearch]![BDR] & "*")
What is the proper syntax to retrieve the BDRs that are populated as well as the null values?
Thank you for your assistance.