Addition in SQL

[Guest_imported]

Hey Guys,

I wanted to add three sums to get a Grand Total.

Here's the dilemma : If any of hte three sums is null, then the GrandTotal sum turns out to be Null as well.
so 4033+3333 +null = null

here's my query: Can anyone help me find the some irrespective of null fields? tks.

""
SELECT ApplicationName, Sum([Amount $]) AS SumOfAmount, Sum(LLR) AS SumOfLLR, Sum([CAD $]) AS SumOfCAD, SumOfAmount + SumOfLLR + SumOfCAD AS TotalSum FROM [TableMain-2]
""

All Help Appreciated. Tks

 

[skapsak]

Try including the function nz([amount]). the "NZ" changes all null values to zero.