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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

many querries into report 4
How to count consecutive records base on 2 groupings 0
RAW MATERIAL QUERRIES 1
help with querry 3
Querry to get unique records from 3
Need a lookup querry 1
Newbie Access Help - Query with calculation.. 0
Update Querry type conversion error 1

Back
Top