I am trying to make a query that returns 0 if no record is found which would mean all conditions are met and the base query would not return anything but I am getting a syntax error.
SQL:
SELECT ISNULL(
SELECT tblMultiConductorCut.TicketID, tblMultiConductorCut.MultiComplete
FROM tblMultiConductorCut
WHERE (((tblMultiConductorCut.TicketID)=[Forms]![frmWireRoom]![TicketID]) AND ((tblMultiConductorCut.MultiComplete)=False)),0);