Total a column in a query

[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.

 

[Van T. Dinh]

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)