query question

B

Bob Matthews

I am using Office97
I have a table in Access with an integer field with values ranging from zero
upwards.
What expression do I use in a query so that the output for this field is

the original value if non-zero
blank if original was zero

Bob M
 
J

John Vinson

I am using Office97
I have a table in Access with an integer field with values ranging from zero
upwards.
What expression do I use in a query so that the output for this field is

the original value if non-zero
blank if original was zero

Bob M
Click to expand...

You can simply set the Format property of the field to:

#;#;"";""

to display the number if it's positive or negative, and blank if it's
zero or null.

John W. Vinson[MVP]
 
Top