SELECT Employee.Name,; IIF(DOW(Date,2)==1,Work_StartTime,0) AS Mo,; IIF(DOW(Date,2)==2,Work_StartTime,0) AS Tu,; .... FROM Plan; LEFT JOIN Employee ON Plan.EmplId == Employee.Id; WHERE BETWEEN(Plan.Date, startDate,startDate+7); INTO CURSOR gridSourceFor Reporting you may need different SELECT.