Expression to not show zero in query

[tmyers]

What would be the correct expression to have a field in a query be Null rather than show 0?

On a form that uses the query as a control source, i tried setting fields default value to null, but it doesnt work.

 

[tmyers]

Can ignore. I found the issue within the table that fixes the problem.

 

[Isaac]

Ok.

But could use an iif statement, or:

Test: Switch([ColumnName]=0,Null)

 

[Pat Hartman]

Formatting such as this is best done on the form or report. Doing this in the query, will make the field not updateable.