How to format a null value to 0?

[ahvc]

Hello

I am using a query in a list in a form. The query fields depends on some values from another form. If the data is not available in the other form, the query is returning 'NULL' value. Their data type is integer. How can format the 'NULL' value fields to a 'zero' value, in the SQL statement of a query.?

Thank you
VC

 

[Rich]

Look up the Nz function

 

[ahvc]

Thank you , Rich.. it was simple, but life-saver for me.. thanks.

Also, can you please tell me how can i format a numeric field on the fly in a query. Like, I want to list the decimal places to 2 (99.99).. apart from defining in a table or form, how can I do this in a query, which I will use in a list.

Thank you
VC