Posted by Duane123 on 10/19/05 10:10

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

[Back to original message]