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

S

Stuart Reicher

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
 
J

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
 
J

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

Stuart Reicher

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...
 
R

Rick Brandt

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.
 
Top