Bernard: Is this based on a table or a view? If it's a view does it by any chance have a UNION clause in it? I have experienced something similar when using a view with a UNION to determine correct data types.
Mike Ramsour AK Steel Coshocton Works Quality Department Phone/VMS: 740-829-4340 -----Original Message----- From: Bernard Lis [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 23, 2008 12:04 PM To: [email protected] 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
