How to on Summation and Count Querries?

  • Thread starter Thread starter Marsha
  • Start date Start date
M

Marsha

I need to do a query that will run and produce a bottom
line/total column with all dollar amounts added up for
one to two columns from a table.

Any help you can offer would be great!

Thanks
 
Hi,


The simplest way is to use a UNION query:


SELECT f1, f2, f3, g1, g2 FROM myTable

UNION ALL

SELECT Null, Null, Null, SUM(g1), SUM(g2) FROM myTable



Hoping it may help,
Vanderghast, Access MVP
 
Back
Top