>>Add

GROUP BY convert(char(11),ft.trans_date,1)

to your select
>
>Folks we have a winner!
>
>Thanks ^256

Jim,

BTW, here's the simplest way to get datime value w/o time portion

GROUP BY DATEADD(day, DATEDIFF(day, 0, ft.trans_date), 0)