Duplicate Values ???

[wisemank]

I have 12 tables (specific years( 2006, 2007, 2008..)) and within each year table there are 2 columns containing Part number & VSC. I am trying to gather every part number and its corresponding VSC from each of the tables without any duplicates. Not sure if query or script will work best. Any ideas?

 

[Joe4]

Create a query from one of the tables that returns the Part and VSC numbers only.
Then changes this to a Union Query, adding all the code from all the other tables.

Do do this, after you create the first query, switch to SQL View. Highlight and copy all the code up to the semi-colon.
Then, just before the semi-colin, type a space, then the word "UNION", then another space, then paste the code you copied.
Now, in the code you just pasted, alter it to reference the next table (change table names).
Then repeat the steps above until you have added a UNION for each table. By nature of UNION queries, all the duplicates should be surpressed (just be sure NOT to include the year field!).

Here is a little write-up on Union Queries, if that helps: Combine the results of several select queries by using a union query - Access

Note, if your database was normalized, this would be very easy to do. In a normalized set up, you would only have one table like this (instead of one for each year), and you would have a year field in your table. So all the years records would be in a single table (in a normalized database, you would not have multiple data tables containing the same structure).