>I am trying to get running totals
See "Running sum" at http://www.artfulsoftware.com/infotree/queries.php.
PB
-
Venugopal Rao wrote:
I am trying to get running totals for the following:
Project Code---R&D---STP--RunningTotal
1007303--04---04---8
1007304
I am trying to get running totals for the following:
Project Code---R&D---STP--RunningTotal
1007303--04---04---8
1007304--04---04---16
I tried to follow the examples available on the site but it is giving errors.
I am using java as a middleware and mysql as back end.
d) Month, Year(DatePaid) Year, count(*) as
Registrations,
Extract(Year_Month from DatePaid) Monindex,
Sum(Amount) as Paid
From Capclavepresent
where ( amount > 0)
Group by Monindex;
/* REPORT FOR BOTH YEARS WITH RUNNING
TOTALS*/
Set @cumreg=0, @cumr
TECTED]>
To:
Sent: Wednesday, August 02, 2006 10:29 PM
Subject: Running Totals?
Back with another registration db question:
Have a convention database which tracks people as they register all year
long; the actual convention is held in October. I've got a fairly simple
query w
2006 10:29 PM
Subject: Running Totals?
Back with another registration db question:
Have a convention database which tracks people as they register all year long; the actual convention is held in October. I've got
a fairly simple query which shows how many people registered in each calenda
At 11:10 PM 8/2/2006, Peter Brawley wrote:
Barry
>It would make life easier if I could also show a column
>with the cumulative count for each month.
Set @cum - 0;
Select
Monthname(DatePaid) Month,
Year(DatePaid) Year,
Count(*) as Registrations,
Extract(Year_Month from DatePaid
Barry
>It would make life easier if I could also show a column
>with the cumulative count for each month.
Set @cum - 0;
Select
Monthname(DatePaid) Month,
Year(DatePaid) Year,
Count(*) as Registrations,
Extract(Year_Month from DatePaid) AS Monindex,
@cum := @cum + Count(*) AS
Back with another registration db question:
Have a convention database which tracks people as they register all year
long; the actual convention is held in October. I've got a fairly simple
query which shows how many people registered in each calendar month--useful
to compare to prior year to
Hi Folks,
I'm using the following SQL SELECT statement to query a list of labor items.
I'm able to compute my number of hours(thanks Paul) and the line amount
(hours*rate=lineTotal) and now what I would like to do is to keep a running
total for hours and lineTotal. Is there any way I can do that
