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