Update a query with a new table

[xxxjorgexx]

Hi,
I am trying to create a database based on project data. I receive a new table each month containing updated project data. I would like to create a query containing some current project information from the current months table, and also containing some historical project information from 2 or more older monthly tables. Each table is structured the same way. Ultimately I'd like an output that contains one project number, and current project data, and historical project data, with space for me to put in notes or flags.

When the new month comes around, and I get a new table, how do I quickly update an existing query to link to this new table without changing the 'Table' on each category/column one by one? Is there a function that will change the all the table links at once? Or do I have to do a macro? Or???

Thanks.

[June7]

Why aren't you importing the data to a single table? Monthly tables is not advisable, should be one table, otherwise have to do a UNION query to get the data into a single dataset structure so can query across all months. There is a limit of 50 lines in a UNION.

Doing the design edits programmatically is much more complicated than properly designing database structure.

[xxxjorgexx]

Thanks, I did that, and played around with it for a while, and I think I'm now able to get my new query to pull the current and historical data on one record.