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

[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

 

[Jeff Boyce]

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

 

[John Spencer]

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])

 

[Guest]

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.

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])

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

 

[Rick Brandt]

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.

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