SELECT Meetings.begintime, Meetings.pname, ; Meetings.p2name, Meetings.p3name, Meetings.surgeon,; Meetings.plname, Meetings.pfname,; Meetings.comments, Meetings.meetingnumber, Meetings.patientphone,; Meetings.dob; FROM sched!meetings ; WHERE Meetings.date BETWEEN ?gd_startd AND ?gd_Endd; AND Meetings.dept = ?gcDept ; UNION ALL ; SELECT BLOCKS.begintime, BLOCKS.pname, ; BLOCKS.p2name , BLOCKS.p3name , BLOCKS.surgeon,; BLOCKS.plname,BLOCKS.pfname,; BLOCKS.comments, BLOCKS.meetingnumber, BLOCKS.patientphone,; BLOCKS.dob; FROM sched!BLOCKS ; WHERE BLOCKS.date BETWEEN ?gd_startd AND ?gd_Endd; AND BLOCKS.dept = ?gcDept