Skip to main content
A
Anonymous
July 25, 2008
Question

Summing up

  • July 25, 2008
  • 2 replies
  • 339 views
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?
    This topic has been closed for replies.

    2 replies

    D
    Dan_Bracuk
    Inspiring
    July 25, 2008
    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.
    N
    Newsgroup_User
    Inspiring
    July 25, 2008
    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.

    A
    Anonymous
    July 25, 2008
    Thanks! If it was easier to find I wouldn't have been here.
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices