Adding totals for fields with same values

[CSJM45]

Ok, I've got a table with data that's been imported from Excel. I need to run a query that pulls the same values of field one and adds the values of field 2. For instance:

Field 1; Field 2
Jones; 200
Smith;150
Jones; 300
Smith;100

In this example, I need the sum of field 2 for the records where Jones is the value in field 1.

So the result in this case is that records where Field 1 = Jones, Field 2 = 500.

Thanks, in advance, for the help!!

 

[AlexN]

This would help :

http://www.youtube.com/watch?v=60o0hRUfBHs

 

[plog]

It's called a totals query: https://support.office.com/en-us/ar...-a-query-430a669b-e7fd-4c4b-b154-8c8dbbe41c8a