Convert Null to 0

[xeen20]

Hi Guys, i have a problem in converting NULL to 0 , i wrote a query which gave me a Null value, But i would like to know if there is any way i can change the NUll value to 0.

ex
SELECT Sum(xxxx) AS yyyy FROM zzzzz WHERE******=#####;

i got NULL.
I need to get 0 instead of Null.

Plz help

 

[boblarson]

Use the Nz function :

Nz(YourField,0)

 

[xeen20]

Thanks for the reply Bob.
I am new to this Access. Could you give me a idea
if
Select xxxx As yy From zzz where a = # gives me NULL

So do i need to write another query

like
NZ(yy,0)

 

[boblarson]

Select Nz(xxxx,0) As yy From zzz where a = #

 

[xeen20]

Thanks Bob