Import New Items Only

[FurtherStill]

First I want to say hello to everyone. This is my first questions and I did not see it posted anywhere else.

How do I create a query to import unique items based off another table in access.

EXAMPLE

TABLE 1 : ITEM# QTY TABLE 2: ITEM# QTY
_________1 ____5 ___________1 ____2
_________2 ____5 ___________2 ____2
_________3 ____5 ___________3 ____2
___________________________4 ____5
___________________________5 ____5
___________________________6 ____5

I would like the query to import only the unique items from TABLE 2 to make TABLE 1 look like:

TABLE 1 : ITEM# QTY
_________1 _____5
_________2 _____5
_________3 _____5
_________4 _____5
_________5 _____5
_________6 _____5

Thank you in advance!

[ItsMe]

Hello and welcome to the forum!

At a glance it is hard to understand what you are trying to accomplish. If I were to venture a guess I would say your table structure is not a conventional approach.

First, if you want a query to "Import", then yes, you need to start by figuring out a way to "Import". If you want a query to "Compare" two tables within a data base, two tables that may or may not contain duplicate data, you need to reevaluate how the data is input into the tables.

So, if the situation is the latter, you need to asses a better way for the user to update table one or update table two. At face value, there does not appear to be any need for both tables.

If you provide a brief backstory how the data got into the tables in the first place, we may be able to offer an approach to solving your problem that you described in post #1.