Calculation Sum to appear at the bottom of one column of numbers

[Guest]

Hi,

I would like to know if it is possible to calculate a column of numbers and
have the result at the bottom of the column once the query is run. What I am
trying to achieve is exactly the same as in Excel when a column of numbers is
calculated with Autosum. I can get an answer with Group By but this places
the answer in the next column and this is not what I want. I can get a
result when I link an Excel spreadsheet but was sure this could be done in
Access without going to the trouble of linking each time.

Any help would be great.

 

[Duane Hookom]

This can be done in a form footer, report footer, or with a union query.

 

[Guest]

Thank you Duane, this helps, will try a Union Query as this information isn't
required on a form or a report.