Bernie, Put the group by after the where clause.
SEL CreditDate,Sum(Creditamount)=s from Credits WHERE Creditdate between 3/1/2008 and 3/31/2008 GROUP BY CreditDate That may be causing it.....not sure why, but the group by should be last anyway. Dawn Hast Office - (828) 646-2669 Cell - (828) 246-8543 "Bernard Lis" <[EMAIL PROTECTED]> wrote on 04/23/2008 11:51:54 AM: > Can anyone see what's wrong here? > Why is this duplicating? > > sel CreditDate,sum(Creditamount)=s from Credits group by CreditDate where > Creditdate between 3/1/2008 and 3/31/2008 > 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 > >
