Summing up

[Guest]

Seem to be having fun with query of queries today... I have a list of schedule activities in an access database that contain the same Description. For instance

1.Act100 = 2
2.Act100 =1
3.Act100 = 8
4.Act200 = 5
5.Act200 = 2

What I am trying to accomplish is I want a query to delivery this data then sum up the Descriptions that are the same.

1.Act100 = 11
2.Act200 = 7

I have been trying query of queries but I keep running into a wall. Any suggestions?

[Newsgroup_User]

chrispilie wrote:
> I have been trying query of queries but I keep running into a wall. Any
> suggestions?

SELECT Description, SUM(Description) as descSum
FROM yourQuery
GROUP BY Description

btw this is all documented.

[Guest]

Thanks! If it was easier to find I wouldn't have been here.

[Newsgroup_User]

chrispilie wrote:
> Thanks! If it was easier to find I wouldn't have been here.

it's in the cfdocs that you can install on your dev server or you can use
adobe's live docs:

http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=using_recordsets_8.html

[Newsgroup_User]

chrispilie wrote:
> Thanks! If it was easier to find I wouldn't have been here.

..or this nifty AIR app:

http://blog.brianflove.com/articles/2008/02/19/cfdocs-on-air/

[Dan_Bracuk]

If Paul's reply was something you had never seen before, your sql is weak. I've heard good things about the book, Teach Yourself SQL in 10 Minutes by Ben Forta.