Report - Column Totals 2

[sanders720]

I have eight columns in a report, each in a txtBox wirl a specific name. I would like to add the values of numbers in the first seven and place the results in the eighth.

I am thinking of somehow using the expression builder with control source, however some fields are blank and will not allow me to do simple addition.

Please help if you can, and thank you!

 

[GingerR]

you can use
...+ blah + nz([Field]) + blah + ...

nz converts a null to zero

if that doesn't work, do

...+ blah + iif([Field] is null,0,[Field]) + blah + ...

 

[ptpaton]

Ginger's suggestion is good, but do your calculations in the query such as:

MySum: [Blah1] + [Blah2] + [Blah3]

Then, in the report, select MySum as your text box's control source. Much faster and a whole lot easier.