Importing(?) data from different table/same database

[mtownbound]

Windows NT
Access 2000


Have tables labeled Jan, Feb, etc. Now I need to have a "2002" table for all of the months/tables data to be combined, otherwise I would have to select each month table to do a report for the whole year. What is the easiest way to accomplish this, without creating a new database? Do I need to export to a new file, then save that table?

 

[nealvenables]

Use a union query, i.e.

Select Col1, Col2, Col3
From Jan
UNION
Select Col1, Col2, Col3
From Feb
UNION
Select Col1, Col2, Col3
From Mar
...
etc.

Call the union query "Year2002".

Your code will be able to read and report from the "Year2002" query as if it were a table.

 

[mtownbound]

Thanks a million!!!