Making zero values not show

  • Thread starter Thread starter Peter Lawton
  • Start date Start date
P

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
 
Peter said:
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.
Click to expand...


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;;" "
 
An alternative is to use an IIF clause in your query.

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