howto copy only newer OrderID data(and the other fields) from one
in [Queries]
|
Prev: howto copy only newer OrderID data(and the other fields) from one table to another table
Next: howto copy only newer OrderID data(and the other fields) from one table to another table
From: Daryl S on 1 Mar 2010 12:19 Bartus - The criteria you need (assuming OrderID is the key field) will be something like this (use your table names): = Not Exists (SELECT 'X' from [newTableName] where [newTableName].OrderID = [oldTableName].OrderID) If you still have problems, post your SQL so we can help more. -- Daryl S "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 > (filters)? > Can somebody help me out, please? > Thank you! > Bart > . > |