I have created an Microsoft Access 2010 database by linking to an Excel spreadsheet. Now the excel spreadsheet contains 2 different worksheets so I had to create two separate tables that hold the information. What I need to do is create a union query so I can combine all the records into one. So for example this is a database of housing records for two different locations and I want to create a query or a report to display all of them together is this possible?