How do I have zero values in a query show as blank

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a numeric field that shows 0 if there is no info in it, the name of
the field is prop no

Thanks in advance
 
Stuart

I'm not real clear what you are trying to do.

Are you saying that you want a numeric field with "0" in it to display as a
blank? What about those instances when "0" means "none-of", rather than "no
answer"?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
You could format zero to show as "". Check out format property.
Numbers have four parts to their format Postive, Negative, Zero, Null.
So a format like

#,###.00;-#,###.00;"";""

might show what you want to see.


Alternative is use a calculated field in your query.
Field: ZeroAsNull: IIF([Your field] = 0, Null, [Your field])
 
Yes I want the field to be blank, we survey properties, some have property
numbers and some don't. The database defaults the value to zero, I don't
want the zeroes to show on the report.

John Spencer said:
You could format zero to show as "". Check out format property.
Numbers have four parts to their format Postive, Negative, Zero, Null.
So a format like

#,###.00;-#,###.00;"";""

might show what you want to see.


Alternative is use a calculated field in your query.
Field: ZeroAsNull: IIF([Your field] = 0, Null, [Your field])




Jeff said:
Stuart

I'm not real clear what you are trying to do.

Are you saying that you want a numeric field with "0" in it to display as a
blank? What about those instances when "0" means "none-of", rather than "no
answer"?

Regards

Jeff Boyce
Microsoft Office/Access MVP
Click to expand...
Click to expand...
 
Stuart Reicher said:
Yes I want the field to be blank, we survey properties, some have property
numbers and some don't. The database defaults the value to zero, I don't
want the zeroes to show on the report.
Click to expand...

Then it would be best to just remove that default value and change all existing
zeros to Null.
 
Back
Top