Making zero values not show

[Peter Lawton]

Is there an expression that will make a zero value (0) not show in a query
result. A blank record is ideal. I want to keep the record in the answer
table so >1 not the solution.

V. grateful for help

Peter Lawton

 

[Marshall Barton]

Is there an expression that will make a zero value (0) not show in a query
result. A blank record is ideal. I want to keep the record in the answer
table so >1 not the solution.

You should not be displaying the results of a query to
users, that's what forms and reports are for.

A good way to hide zero values is to use a custom format for
text box or query field. Check Help for Format Property for
details, but an example for a long integer value could be:
0;;" "

 

[John Spencer]

An alternative is to use an IIF clause in your query.

Field: NewNameForSomeField: IIF([SomeField] = 0, Null, [SomeField])