I have a table with Attendance Records from 2009 and a table with Attendance Records from 2010. Each table has a field called Times Tardy, Sick Days, Personal Hrs., etc. Our Perfect Attendance goes from October of 2009 to September of 2010. How can I create a query that I can choose any dates (ex. 10/01/2009 and then 09/30/2010) and have it pull the Times Tardy, Sick Days, and Personal Hrs from both Tables?
