PARAMETERS [Формы]![Main_menu]![date_Mon] DateTime, [Формы]![Main_menu]![date_Sun] DateTime;
TRANSFORM Max(z_VSE_zanyatiya_max_priority.id_client) AS [Max-id_client]
SELECT z_VSE_zanyatiya_max_priority.id_time, Max(z_VSE_zanyatiya_max_priority.teacher_name) AS [Max-teacher_name], Max(z_VSE_zanyatiya_max_priority.class_name) AS [Max-class_name]
FROM z_VSE_zanyatiya_max_priority LEFT JOIN z_weekday ON z_VSE_zanyatiya_max_priority.date_name = z_weekday.date_name
GROUP BY z_VSE_zanyatiya_max_priority.id_time
ORDER BY z_weekday.wd
PIVOT [z_weekday.wd] In (Пн,Вт,Ср,Чт,Пт,Сб,Вс);