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) AS Monindex, @cum := @cum + Count(*) AS 'Year to date' >From capclave2005reg Where year(DatePaid)=2004 and (amount > 0 or Dealer = 'Y') Group by Monindex ; PB
Looked promising, but gets me the following, which isn't quite right: +-----------+------+---------------+----------+--------------+ | Month | Year | Registrations | Monindex | Year to date | +-----------+------+---------------+----------+--------------+ | October | 2004 | 23 | 200410 | 23 | | December | 2004 | 5 | 200412 | 5 | | January | 2005 | 9 | 200501 | 14 | | February | 2005 | 11 | 200502 | 16 | | April | 2005 | 2 | 200504 | 7 | | May | 2005 | 48 | 200505 | 53 | | June | 2005 | 45 | 200506 | 50 | | July | 2005 | 10 | 200507 | 15 | | August | 2005 | 17 | 200508 | 22 | | September | 2005 | 58 | 200509 | 63 | | October | 2005 | 97 | 200510 | 102 | +-----------+------+---------------+----------+--------------+ Barry -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]