<p>I can't quite figure this out. Microsoft Access 2000, on the report total section I have totals for three columns that are just numbers. These <code>=Sum[(ThisColumn1)], 2, 3</code>, etc and those grand totls all work fine.  </p>

<p>I want to have another column that says <code>=Sum([ThisColumn1])+Sum([ThisColumn2]) + Sum([ThisColumn3])</code> but can't figure those one out. Just get a blank so I am sure there is an error.</p>

Give the 3 Grand Totals meaningful Control Names and then for the Grand Grand Total use:
```
```
=[GrandTotal1] + [GrandTotal2] + [GrandTotal3]
```
```
Your Grand Total formulas should be something like:
```
```
=Sum(Nz([ThisColumn1], 0))
```
```