Find the sum of similar entries

  • Thread starter Thread starter Dimitris
  • Start date Start date
D

Dimitris

Hello in table I have entries in Field1 that have a number next to them in
Field 2:
Field1 Field 2
ABC 5
ABC 9
ADD 6
RFF 8
ABC 5
ADD 1
etc.

I need to see the sum of every similar entry of Field1. For example using
the above data I need to see:
ABC 19
ADD 7
etc.

So I need the sum of every similar entry of Field1.

Can someone please help since I am new in Access?

Thank you
Dimitris
 
In query design view
== Open new query
== Add your table to the query
== Select Field1 and Field2 as fields
== Select View: Totals from the menu
== Change GROUP BY to SUM under field2


John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County
 
Thank you


? "John Spencer said:
In query design view
== Open new query
== Add your table to the query
== Select Field1 and Field2 as fields
== Select View: Totals from the menu
== Change GROUP BY to SUM under field2


John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County
Click to expand...
 
Back
Top