Query leaving feilds with zeros blank

[Yes]

I have created a query that uses a formula in one of the feilds that relies
on adding two other feilds. In the table that one of the columns is pulled
from there are zeros. When the query pulls in the information it leaves
those feilds with zeros blank. My formula returns a blank value for any of
the fields that have zeros.

How can I make the query pull those zeros over???

Thanks in advance........

 

[John Vinson]

I have created a query that uses a formula in one of the feilds that relies
on adding two other feilds. In the table that one of the columns is pulled
from there are zeros. When the query pulls in the information it leaves
those feilds with zeros blank. My formula returns a blank value for any of
the fields that have zeros.

How can I make the query pull those zeros over???

Are they in fact zeros, or are the fields NULL (perhaps with a format
which makes them appear as a zero)?

Use NZ([fieldname]) in your formula to convert NULL to zero, would be
my suggestion.

 

[Yes]

I have created a query that uses a formula in one of the feilds that relies
on adding two other feilds. In the table that one of the columns is pulled
from there are zeros. When the query pulls in the information it leaves
those feilds with zeros blank. My formula returns a blank value for any of
the fields that have zeros.

How can I make the query pull those zeros over???

Are they in fact zeros, or are the fields NULL (perhaps with a format
which makes them appear as a zero)?

Use NZ([fieldname]) in your formula to convert NULL to zero, would be
my suggestion.

I don't see any kind of format setting for that field, but it's very likely
that they are NULL. The data base is populated by an application with a text
box. I would imagine this feild is skipped over regularly. I'll try the NZ
function and see if that helps.

Thanks.

 

[Yes]

I have created a query that uses a formula in one of the feilds that relies
on adding two other feilds. In the table that one of the columns is pulled
from there are zeros. When the query pulls in the information it leaves
those feilds with zeros blank. My formula returns a blank value for any of
the fields that have zeros.

How can I make the query pull those zeros over???

Are they in fact zeros, or are the fields NULL (perhaps with a format
which makes them appear as a zero)?

Use NZ([fieldname]) in your formula to convert NULL to zero, would be
my suggestion.

I don't see any kind of format setting for that field, but it's very likely
that they are NULL. The data base is populated by an application with a text
box. I would imagine this feild is skipped over regularly. I'll try the NZ
function and see if that helps.

Thanks.

That did the trick! Thanks alot for your help!