Total a column in a query

  • Thread starter Thread starter Rick Colvin
  • Start date Start date
R

Rick Colvin

I have a real basic question: How do you simply add the
totals in a column in a filtered query? I have 115
records, the last column is a dollar value for our
inventory. I simply want to total that column to see
what the total value of our inventory is. I created a
filtered query but you can't use the SUM function like in
Excel. In Excel, all you do is hit one button and it
automatically adds the total of that column. How do you
do that in Access??? I'm a rookie.
 
Access is different from and a lot more strutured than
Excel. Access and Excel are different applications used
for different purposes.

In a Query result set, each row is of the same structure,
i.e. each row is a (more or less) Record from your Table.
You cannot (not usually done, anyway) have X rows as
Records from your Table + 1 row at the end as the Totals
row.

You can, of course, create a Query that simply return 1
Totals row.

Generally to show both the Detail Records plus Totals, you
design an Access Report which can show / print both Detail
Records + the totals at the end.

HTH
Van T. Dinh
MVP (Access)
 
It sounds like you want to use a query as a sheet in an Excel file.
They don't work the same way. They both have their uses.

You can send a query's result to Excel with just a single click and then
do your sum, or you can sum in a query, although it does not work like
Excel.

When making the query use the wizard and select the sum option when
offered. You can also use the sum feature on an existing query once you get
the idea of how it works. Play with it a few times and learn what SUM,
GROUP ON, and FIRST OF all mean. Read the help files. It may do what you
need. You may also need to use a Report. Reports also sum but work a
little different.
 
Back
Top