Display zero instead of null? Access 2013

[Lynn Cohen]

The disclaimer: I'm not a programmer.



I have a query in Access 2013 that returns a null value. I'd like to make it display a zero instead of the null. I've searched on uses of IsNull and Nz but can't seem to make either work. Can someone give me the specific verbiage for the criteria in Expression Builder?

Query 1 lists open projects. Fields in this query are:

Who Owns
Project Name
End Date (criteria = null)

Query 2 counts open projects by project type. Fields in this query are:

Who Owns (set to Group By)
Who Owns (set to Count)

Query 2 returns these results:

Type A 134
Type B 3
Type C (null)
Type D 60

I'd like to make that null value for Type C display as a zero.

Many thanks!

[CJ_London]

set the format property where you are displaying the data - perhaps your query but should be form or report
;;;0