I need another set of eyes to see what I am missing as I am unable to figure out why I am getting a syntax error on :
MultiCut: IIf(IsNull(DCount("CutLength","tblMultiConductorCut","TicketID = " & [Reports]![rptWireRoom]![TicketID]))=True, 0 ,DCount("CutLength","tblMultiConductorCut","TicketID =" & [Reports]![rptWireRoom]![TicketID]))
I am trying to count records based off "CutLength" using TicketID from my report (not form) and return 0 if there are no records so I do not get #ERROR in my control as I am doing multiple DCounts and doing some adding and multiplying. This is based in the reports control query and I do all the adding and such in the control on the report itself.
MultiCut: IIf(IsNull(DCount("CutLength","tblMultiConductorCut","TicketID = " & [Reports]![rptWireRoom]![TicketID]))=True, 0 ,DCount("CutLength","tblMultiConductorCut","TicketID =" & [Reports]![rptWireRoom]![TicketID]))
I am trying to count records based off "CutLength" using TicketID from my report (not form) and return 0 if there are no records so I do not get #ERROR in my control as I am doing multiple DCounts and doing some adding and multiplying. This is based in the reports control query and I do all the adding and such in the control on the report itself.