Calculating with null values

I have 2 separate queries, one produces a total and one doesn't at the moment as the criteria are not met.

I want to add the total field from both these queries together but becuase one is null value, the sum total is also null.

In access I would have used nz([Qry_1].[Total])+nz([Qry_2].[Total]) to get over this but SQL/adp doesnt seem to understand this.

Can you help?coalesce([Qry_1].[Total],0)+coalesce([Qry_2].[Total],0)|||This worked perfectly - thanks so much