Sum function only works when BOTH columns have a value

[Tasca]

Hi

I have a query that has amounts in two columns. What I am trying to do is add a 3rd column which shows the total. However, the function only works if BOTH of the columns have a value. If only one column has a value the total column returns a null......

I am using

Total: [SumTC]![SumOfAmount]+[SumChAgreed]![SumOfAmount]

built using the Function Wizard in Access to add the two columns where SUMTC and SumChAgreed are 2 copies of a query which have different filters on the same table to get the values and SumOfAmount in both is the total sum for each element within the tables.

 

[lespaul]

use the NZ function maybe:

Total: NZ([SumTC]![SumOfAmount], 0)+ NZ([SumChAgreed]![SumOfAmount], 0)

Leslie

Have you met Hardy Heron?

 

[Tasca]

Knew that was too good to be true, had no effect. Thanks for the prompt response

 

[Tasca]

Ooops!!!


Sorry my mistake that DID work. Thanks very much