coopeed
09-21-2007, 06:38 AM
Hi All.
I am unable to retrieve records with a zero dollar amount or is null when the user selects '0' from the combobox on a form. I have the following in the criteria on my query:
IIf(([forms]![form1]![combo2]=0),([tblApprovalAmounts].[AMOUNT]) Is Null Or ([tblApprovalAmounts].[AMOUNT])=0,[forms]![form1]![combo2])
Any ideas on what may be wrong?
Thank you for your help.
I am unable to retrieve records with a zero dollar amount or is null when the user selects '0' from the combobox on a form. I have the following in the criteria on my query:
IIf(([forms]![form1]![combo2]=0),([tblApprovalAmounts].[AMOUNT]) Is Null Or ([tblApprovalAmounts].[AMOUNT])=0,[forms]![form1]![combo2])
Any ideas on what may be wrong?
Thank you for your help.