>what is the definition of b.dthours > >Peter > >>Here is the Select Statement >> >>SELECT a.weekday, ; >> SUM(000000000000.00000 + b.dthours) as Downtime ; >> FROM tmpdays a ; >> LEFT OUTER JOIN tmpDowntime b ON DTOS(a.weekday) = DTOS(b.report_date) ; >> GROUP BY a.weekday ; >> INTO CURSOR tmpHope2 >> >>Rex A. Walters