Find the sum of similar entries

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
 
J

John Spencer

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
 
D

Dimitris

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

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

make field with sql or iif 5
Transpose 2 rows to 2 columns 1
Update blank/null fileds with value of previous row using update q 2
Running Sum Query of Ranked Data 6
Select to reference an other record or row 1
Scaling results in data truncation 2
TOP 5 AND SUM EVERYTHING ELSE 2
Sum, Minimum and Maximum with a twist... 2

Top