Counting Records Question

[HakanAzaklioglu]

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

[JoshT]

I believe the correct SQL syntax is like:

SELECT Location, SUM(QTY) FROM ...

[HakanAzaklioglu]

Here is how I adopted your code to work in my page:
===================================================================
SELECT LOCATION, SUM(QTY) FROM MAIN WHERE LOCATION = 'FTM'
===================================================================

When I tried your code, here is what I got as a error message:
===================================================================
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] You tried to execute a query that does not include the specified expression 'QTY' as part of an aggregate function.
===================================================================

Any suggestions,
Hakan

[JoshT]

SELECT Location, SUM(QTY) AS SUMQTY FROM Main
GROUP BY Location;

[HakanAzaklioglu]

You are awesome man... I have never come across using the sum command in sql statement. You recommend any books or www sites I can check out to do some homework on code applications like the one you just showed me...

Greatly Apreciated,
Hakan

[JoshT]

You're welcome. Try http://www.w3schools.com/sql/default.asp