I have designed a database to retain information on Customers I have contacted. I am attempting to design a form that will generate a report (based on a query) that is filtered by a date range and Multiple checkboxes. I was able to get the date range to work efficiently, however, I am having trouble with the Check boxes. There are 5 checkboxes total (defined by the "Status" of a call I.E. No Answer, Wrong number, etc.).
In design view of the Query I have IIf([Forms]![FrmInstallsCB]![CBMovedUp]=-1,"Moved Up","") in the Criteria. When I use the form I get an error "This expression is typed incorrectly, or it is too complex to be evaluated.
SQL
SELECT TblInstalls.[CONT DATE], TblInstalls.[SCH DATE], TblInstalls.AREA, TblInstalls.[CUSTOMER #], TblInstalls.CITY, TblInstalls.[#], TblInstalls.STATUS, TblInstalls.COMMENTS
FROM TblInstalls
WHERE (((TblInstalls.[CONT DATE]) Between [Forms]![FrmInstallsCB]![TxtStrtDate] And [Forms]![FrmInstallsCB]![TxtEndDate]) AND ((TblInstalls.STATUS)=IIf([Forms]![FrmInstallsCB]![CBMovedUp]=-1,"Moved Up","0")));
I am relatively new to Access.
Can anyone tell me what I am doing incorrectly?
Thank you,