[RBASE-L] - RE: Group by -- need another set of eyes

[Bernard Lis]

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 
  To: RBASE-L Mailing List 
  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