sum of sums

[Duane123]

Hello, any help is appreciated.
Here is what I’m trying. I want a month to date total of bookings
based on a fiscal month.
I can isolate my records for the month and sum up the days so I wind
up with a list of days of the month with their bookings total for
that day. Like this
10/1/05 - $1000
10/2/05 - $5000
10/3/05 - $2000
And so on thru the month.
But I want the sum of month 10.
I have a line of code like “select sum(EXT_AMT) where month = “10””
What I need is sum(sum(EXT_AMT).
And that does not work.
Any suggestions? I thought to throw the results into a table then sum
the table.
Not sure how to do that either! I'm frustrated! Any help is
appreciated.
Thanks, Duane

[Jens]

What about a subquery ? 8Just to show you an example

Select SUM(Col1)
FROM
(
select sum(EXT_AMT) Col1 where month = "10"
) SubQuery

HTH; Jens Suessmeyer.

[Gert-Jan Strik]

Duane,

The statement “select sum(EXT_AMT) where month = '10'” would give just
one total. Maybe there is still a GROUP BY clause in the same query that
you need to remove.

Gert-Jan
Duane123 wrote:

Hello, any help is appreciated.
Here is what I’m trying. I want a month to date total of bookings
based on a fiscal month.
I can isolate my records for the month and sum up the days so I wind
up with a list of days of the month with their bookings total for
that day. Like this
10/1/05 - $1000
10/2/05 - $5000
10/3/05 - $2000
And so on thru the month.
But I want the sum of month 10.
I have a line of code like “select sum(EXT_AMT) where month = “10””
What I need is sum(sum(EXT_AMT).
And that does not work.
Any suggestions? I thought to throw the results into a table then sum
the table.
Not sure how to do that either! I'm frustrated! Any help is
appreciated.
Thanks, Duane