SELECT ; crsSchedule.S_RefProv AS ProvID, ; crsSchedule.S_RefName AS ProvName, ; crsSchedule.S_Pat_Num AS ContactID, crsSchedule.S_Pat_Name AS SchedName, ; crsSchedule.S_Phone AS SchedPhone, ; crsSchedule.S_Date AS SchedDate, ; ALLTRIM(STR(crsSchedule.S_hh)) + ':' + ALLTRIM(STR(crsSchedule.S_mm)) AS SchedTime, ; crsSchedule.S_Off AS LocCode ; FROM crsSchedule ; INTO CURSOR crsApptBox