A
A-rod
Guest
I have a query that I'm wanting to run off a form. Users enter in the criteria into several form feilds. I used the below expression for feild, only with different form feild names. Expr1: IIf(IsNull([Forms]![frmbamatrix]![causeofloss1]),"",[tblbapmatrix]![Covgdetail]=[Forms]![frmbamatrix]![causeofloss1]), The criteria is <>False. I want the query to run as or statement. If I enter two criteria it searches for both. However if I only want to enter one peice of criteria it will only look for the one. I am having problems getting it to look for only one item. Any assistance would be great. Thanks
