This is an intersting question I can't figure out.

I have a database that has data in the following format:

====================
LOCATION QTY
FORT MYERS 10
NAPLES 12
NASHVILLE 18
FORT MYERS 15
NASHVILLE 12
NAPLES 22
====================

What I want to do is, on an asp page, have it say:

====================
LOCATION QTY
FORT MYERS 25
NAPLES 34
NASHVILLE 30
====================

Any solutions/ideas are better than no solutions/ideas

All help apreciated

Kind Regards,
Hakan