Help on Calculation

[Huddle]

I am trying to put zeros in the blank field of a report. I've tried this calculation as well as others but it is not producing the results. This is in a query. Can you help correct it?



Assessments In Progress: (IIf([CountOfDistrict]="","0",[CountOfDistrict]))

[Minty]

I suspect that count district is returning a null not "". Try simply

Nz([CountofDistrict],0)

The Nz() function will replace a Null value with the second argument.

[Micron]

Count of something implies it is numeric, so ?
IIf([CountOfDistrict]= 0,0,[CountOfDistrict])

On second thought, maybe not as that doesn't make a whole lot of sense even if it worked. Whatever the calculated field name is, if it's numeric its expression might just as well be CountOfDistrict

[Huddle]

Got it working with the Nz([CountofDistrict],0) formula. Thanks for your help