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???