Null and 0 values

[MoeIndustries]

Hello, I have a query feeding into a report. In the report I want to display any nill or 0 results as a dash "-".



I'd like to write this into the report rather than the query (but if I have to I will write into the query).

I've used the NZ function but it doesn't work!

In the report against the property "Control source" I have [Unrestricted] so I tried =Nz([Unrestricted],0) but get nothing.

How do I do this???

[ranman256]

DONT put it in the report, put it in the query. NZ does work.

[MoeIndustries]

Ah, OK. Here's the code I'm using and the result showing the nill NOT as 0.