Total a column in a query

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

Guest

Is it possible to see the total of a column on the display screen of a query?
If so, how do you accomplish this?
 
Queries return rows. If you want to see (only) a total, use a TOTALS query.
If you want to see the detailed row values and a total, use a report based
on the query.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
There is no way to have the column total actually print at the bottom of a
query column? I would like to see something similar to Excel's ability to
total a column, but still be able to use Access.
 
Normally this is done in a form or report. If you really want this in a
query, you may need to create a union query that unions the details and a
summary query.
 
It sounds like you want Access to behave like Excel. Could you export your
query to Excel and show the column totals there?

Regards

Jeff Boyce
Microsoft Office/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

Query to display highest totals 1
Total Row to Sum a Column 1
Column Total 3
Return total of totals? 2
Summary row in crosstab query? 3
running total of records in query 1
Count text values in a Access Field 0
Query using two separate query totals 3

Back
Top