Calculations in a query.

[bassl1ne]

I have created a select query that is required to add 2 fields together and store this in another field. Fields 1 & 2 contain values from another query, Field 3 contains the result.

The problem is that if either of the fields doesn't contain a value (is null) then the addition will not work. How can i make a null field equal to 0 so i can still total the sum?

Hope thats enough info, please help...

 

[Liv Manto]

nz function

 

[bassl1ne]

Easy when u know how huh!?, thanks, saved me many hours