SELECT ProgramEye, ProgramLink FROM foo_Program ORDER BY ProgramLink ASC SELECT foo_Calendar.CalendarEye, foo_Calendar.Calendar_Date, foo_Calendar.Calendar_Time, foo_Calendar.Calendar_Notes, foo_Calendar.OfficeEye, foo_Calendar.RoomEye, foo_Calendar.ClassEye, foo_Calendar.ProgramEye, foo_Calendar.InstructorEye, foo_Calendar.ContactEye, foo_Calendar.CreateLink, foo_Class.ClassEye, foo_Class.Classtitle, foo_Instructor.InstructorEye, foo_Instructor.FirstName, foo_Instructor.LastName, foo_Program.ProgramEye, foo_Program.ProgramLink, foo_Room.RoomEye, foo_Room.RoomName FROM foo_Calendar, foo_Class, foo_Program, foo_Room, foo_Instructor WHERE foo_Class.ClassEye = foo_Calendar.ClassEye AND foo_Instructor.InstructorEye = foo_Calendar.InstructorEye AND foo_Program.ProgramEye = foo_Calendar.ProgramEye AND foo_Room.RoomEye = foo_Calendar.RoomEye ORDER BY Calendar_Date ASC, Calendar_Time ASC SELECT tble_Office.OfficeEye, tble_Office.City, tble_Office.COMPANY_NAME FROM tble_Office WHERE tble_Office.OfficeEye = '#CalendarView.OfficeEye#'

Education

Program Links #ProgramLink.ProgramLink#

Calendar of Events Office Sign Up Time View Class Program Instructor #CalendarView.OfficeEye# #LEFT(rs_Office.COMPANY_NAME, 3)# #LSDateFormat(CalendarView.Calendar_Date, 'MM/DD/YY')# #LSDateFormat(CalendarView.Calendar_Date, 'MM/DD/YY')# #LSTimeFormat(CalendarView.Calendar_Time)# #CalendarView.Classtitle# #CalendarView.ProgramLink# #CalendarView.FirstName# #CalendarView.LastName#