Bernie - The WHERE clause comes before the GROUP BY clause:
sel CreditDate,sum(Creditamount)=s from Credits + where Creditdate between 3/1/2008 and 3/31/2008 + group by CreditDate Sami ____________________________ Sami Aaron Software Management Specialists 913-915-1971 [EMAIL PROTECTED] -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Bernard Lis Sent: Wednesday, April 23, 2008 10:52 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Group by -- need another set of eyes Can anyone see what's wrong here? Why is this duplicating? CreditDate sum (Creditamou ---------- --------------- 03/23/2008 2,952.16 03/30/2008 2,819.19 03/23/2008 2,952.16 03/30/2008 2,819.19 ---------- --------------- 11,542.70
