Combine tables

[JoeCL]

Hello!

I am not a regular Access guy so pardon if the problem is
simple for you. I inherited an Access application that has
5 different table names but the structure. That is 1 for
each year. Example would be tbl1998, tbl1999, tbl2000,
etc. With this name the application reports, queries would
not work. Ex. so to work on table for year 2000 I had to
rename tbl2000 to maillist then I can run the reports and
queries then rename it back. The same steps if I want to
process another year, say 2001, and so on. I planned to
combine all these tables in to one table and just create a
parameter query to specify the year. How do I combine
these tables?

Thanks.

 

[Douglas J. Steele]

Create a new table that has the identical structure, but add one more field
to it to store the year. (It should be an Integer)

When you're creating the index on the new table, choose all of the fields
that are in the index for any of the other tables, plus the year.

Write 5 different Append queries, one for each of the existing tables. Drag
all of the fields to the grid, and create a computed field to represent the
year. (i.e.: when you're dealing with tbl1998, have a field WhatYear: 1998).