Bernie Is the date field actually a datetime field?
Buddy ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Bernard Lis Sent: Wednesday, April 23, 2008 1:33 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Group by -- need another set of eyes Hi Ben, I tried it without the =s and get the same duplicate figures, just without the total. If I leave out the group by, I get the correct total. ----- Original Message ----- From: Ben Petersen <mailto:[EMAIL PROTECTED]> To: RBASE-L Mailing List <mailto:[email protected]> Sent: Wednesday, April 23, 2008 1:20 PM Subject: [RBASE-L] - RE: Group by -- need another set of eyes Hi Bernie, > sel CreditDate,sum(Creditamount)=s from Credits + > where Creditdate between 3/1/2008 and 3/31/2008 + > group by CreditDate Shouldn't sum(Creditamount)=s be sum(Creditamount)? I think the =s parameter is used in a different context????? Ben
