I usually dont have many issues in access but can't seem to remember how to do this for the life of me. I have tables that are added to the database monthly with the exact same column headers and the name of the table only differs by the period. For example one table would be "200901 Rev" and another would be "200902 Rev". I'm looking to make a query to pull the same information from each table but need to run it for multiple periods...for example 200901-200906. Any help would be greatly appreciated. Thanks!