How to sum a column in a query

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

Guest

I am new to Access, and I need to get a quick total of a column of dollar
amounts. Currently, my query returns a list that is basically like this:
Invoice number Amount
99999 100.00
88888 200.00
77777 300.00

I need a total of the Amount column and I haven't been able to get one.
Please help.
- Gail M.
 
All you need to do is...
Create a Query based on the appopriate Table.
Drag down ONLY the Amount field.
From the File Menu | View | Totals
Click the DropDown next to Group By and select Sum. This will give you the
sum of the Amount field for every record with a value in that field.

Now if you need to do some filtering you can drag down other fields from the
Table into your Query, but these fields can't be shown. They are there for
criteria purposes only. Change the Group By field to "Where". If you want
to Group By Department or Sales Rep or something, you leave that field as
shown, and utilize the Group By feature as is. You'll have a result as
follows...
Sales Rep Amount
Person A 20
Person B 40
Person C 80
But you won't get a grand total. Hope this helps.
 
On Mon, 7 Feb 2005 14:39:04 -0800, "Gail Moser" <Gail
I am new to Access, and I need to get a quick total of a column of dollar
amounts. Currently, my query returns a list that is basically like this:
Invoice number Amount
99999 100.00
88888 200.00
77777 300.00

I need a total of the Amount column and I haven't been able to get one.
Please help.
- Gail M.
Click to expand...

Two ways:

- To get just the total, create a Query based on your Table. Change it
to a Totals query by clicking the Greek Sigma icon (looks like a
sideways W). Select only the Amount field and choose Sum as the
operator (where it says Group BY).

- Or, to see the detail data and also a sum, create a Form (for
onscreen) or Report (for printing) based on the table; use View to
view the Form (or Report) footer; put a textbox in the footer with a
control source

=Sum([Amount])

John W. Vinson[MVP]
 
Back
Top