Identifying identical rows and combining those into one unique row

[Mallards]

I am trying to figure out how to deal with a database that has some duplicate records. Technically, they are not duplicates, rather they are rows of data with identical data that need to be added up together. I need to 1. identify matching records and 2. combine those records to make one unique record. An example is easier!

Easting	Northing	Species	Number
539884	4942158	Shrew	5 <--
539884	4942158	Shrew	5 <--
539884	4942158	Squirrel	10
539777	4942222	Shrew	5

The underlined rows are matching records that need to be added together so my table will look like this:

Easting Northing Species Number 539884 4942158 Shrew 10 <-
539884 4942158 Squirrel 10 539777 4942222 Shrew 5

I am having trouble figuring out the best type of query to deal with this- any suggestions?

[offie]

Have you tried GROUP BY? You can do this is SQL or in design view hit the Totals button up top, a row shows up at the bottom, select group by for the first three and sum for the last one. I'm not sure exactly how your data is set up so this might or might not work