Hello all,

I'm looking at a database that was created by another person and there seems to be this tiny issue i can't figure out. There are 3 rows that comes in with the same descriptions but a different amount. I was wondering how i can add them together and make it just one row with the total?

i.e. - Des Amt
Abc 100
cde 100
fgh 200

Abc 500 - how can i take the 100 and add it to the 500 and delete the row with the 100?

thank you.

Hi
We will need to know more about the origin of these figures before we start "tweaking" them, can you give more details.
(IMG:http://www.utteraccess.com/forum/style_emoticons/default/thumbup.gif)

The data comes from a file that gets translated into a table.

basically there are extra rows with the same information except for one column. So i just need to sum up that column base on the name of the field.