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 500 - how can i take the 100 and add it to the 500 and delete the row with the 100?