Sum / Nz In Detail Section

[crimedog]

I have an unbound Text Box in the Details section of a report


I have: =IIf(DCount("*","[QuryRepDealsM1Comm]")=0,0,Sum([QuryRepDealsM1Comm]![RepMPS]))
This is returning #error

I have tried =IIf(DCount("*","[QuryRepDealsM1Comm]")=0,0,Nz(Sum([QuryRepDealsM1Comm]![RepMPS]),0))

I have tried =IIf(DCount("*","[QuryRepDealsM1Comm]")=0,0,Sum(Nz([QuryRepDealsM1Comm]![RepMPS],0)))

both continue to give me errors - the DCount function is working correctly

The field [RepMPS] does contain nulls - and is not a calculated field.

[ranman256]

Instead of doing this logic, put the condition in a query, then the text box looks at the field result.