Replacing blanks with zeros

[Mr. Smiley]

Is there an easy way to replace blanks with zeros in the results of a query.
I need to use the results of query A to do calculations in query B, but some
of the fields that should contain zeros contain blanks. Thanks.

 

[tina]

you can use a calculation in each query field that needs to be a zero, as

CalcField: Nz(MyField), 0)

or

CalcField: IIf(MyField Is Null, 0, MyField)

hth

 

[Al Camp]

Use the NZ function.
If Qty is sometimes blank...
=Price * NZ(Qty)
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

 

[Ofer]

Try using NZ function

NZ([FieldName],0)

 

[Mr. Smiley]

Thanks you all for your help. I the problem to work using tina's solution.

Try using NZ function

NZ([FieldName],0)

--
I hope that helped
Good luck

Is there an easy way to replace blanks with zeros in the results of a query.
I need to use the results of query A to do calculations in query B, but some
of the fields that should contain zeros contain blanks. Thanks.