From: Marshall Barton on
Bartus wrote:

>howto copy only newer OrderID data(and the other fields) from one
>table to another table
>So the new table is updated only with the new OrderID and the
>OrderID's already copyied earlier are not also added everytime.
>i use the append query i think and need certainly some criteria

INSERT INTO table2 (OrderID, f1, f2, ...)
SELECT OrderID, f1, f2, ...
FROM table1 INNER JOIN table2
ON table1.key = table2.key
WHERE tabl2.key Is Null

MVP [MS Access]