Need to sum up two columns in Access 2007

[meright]

Hi, I'm new to Access programming and I would really appreciate some help on a project I've been working on.



So far I've been doing better than I expected but halfway through the programming I stumbled upon something I don't know how to do.

I have two columns that sum up their own objects (A and B columns) and display it in the last row. now I want a column that sums up the objects of A and B columns and also at the last row sums up all the sums of all A and B cells.

You can see the demonstration of what I mean in the image attached.

I'd appreciate it if anyone could help me out with this.

Thanks!

[boblarson]

The sum would be:

=Sum(Nz([A],0)) - Sum(Nz([B],0))

You should use the Nz function on your other calculations too, in case of a null, it won't return a null then.