Query leaving feilds with zeros blank

  • Thread starter Thread starter Yes
  • Start date Start date
Y

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........
 
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???
Click to expand...

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.
 
John Vinson said:
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???
Click to expand...

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.
Click to expand...

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 said:
John Vinson said:
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???
Click to expand...

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.
Click to expand...

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.
Click to expand...

That did the trick! Thanks alot for your help!
 
Back
Top