Query sum is not appearing

[trident]

I have several columns, and the sum of each column was taken, a 11th column was prepared to get the total sum of each row (Expr2), however, the sum of each row did not appear except for the row wherein all columns have data. Can any body help, a picture is attached.

the formula written is: [SumofTT1]+[SumofTT2]+[SumofTT3]+[SumofTT4]+[SumofTT5]+[SumofTT6]+[SumofTT7]+[SumofTT8]+[SumofTT9]+[SumofTT10]



i only got the desired result when all the coloumns have data, but for the others it was blank which should not be.
+
Thank you for your assistance.

Trident.

[Bob Fitz]

Try using the NZ() function. Something like:
Nz([SumofTT1],0)+Nz([SumofTT2],0)+Nz([SumofTT3],0) etc

[trident]

what is the meaning of NZ and the 0 at the end.

[Bob Fitz]

what is the meaning of NZ and the 0 at the end.

See: http://www.techonthenet.com/access/f...dvanced/nz.php