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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Thank you Duane, this helps, will try a Union Query as this information isn't
required on a form or a report.
 
Back
Top