Crazy stuff! Reload your database and see what you get then... Sami
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Bernard Lis Sent: Wednesday, April 23, 2008 11:04 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Group by -- need another set of eyes Hi Sami, You mean like this: sel CreditDate,sum(Creditamount)=s from Credits where Creditdate between 3/1/2008 and 3/31/2008 group by CreditDate 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 ----- Original Message ----- From: "Sami Aaron" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[email protected]> Sent: Wednesday, April 23, 2008 11:58 AM Subject: [RBASE-L] - RE: Group by -- need another set of eyes > 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 > > >
