I have three tables; they hold the prefix data for three totally different detailed tables.  I need to use some of their three table data fields,  Date Time, Event Type, Comment in these tables as the data used in the Calendar program from the Calendar seminar.   The same data is used in another report.
I need to combine the three tables into one new fresh table ordered by date time so it can be loaded into the calendar.  Can this be done in a button along with Criteria to set the date range of data?