I am COMPLETELY new to queries within Access. Here is my situation. I have built a database to handle specific projects. I have created tables based on each of these projects. The tables all contain the same fields, but the data is unique by project name.
The question (or problem) I have is how to create a query that can pull the same fields from ALL the tables and place it into a designed report. (Example: I want to see ALL records from ALL tables that were input by ******)

I am hoping that I have created the database appropriately. Can someone point me in the right direction. I am not asking anyone to hold my hand through it, but I am completely stupified right now....HELP!!

Creating a separate table for each project is not appropriate. Use a single table with an additional column that identifies the project.