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

[Bernard Lis]

Hi Buddy,
No, it is defined as Date, but good thought anyways.
Bernie Lis
  ----- Original Message ----- 
  From: Walker, Buddy 
  To: RBASE-L Mailing List 
  Sent: Wednesday, April 23, 2008 1:40 PM
  Subject: [RBASE-L] - RE: Group by -- need another set of eyes


  Bernie

    Is the date field actually a datetime field?

   

  Buddy

   


------------------------------------------------------------------------------

  From: rbase-l@rbase.com [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 

    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