Appending Records, but not the duplicates

[Jarad]

I have a query that will pull records, and append them to the table. The only problem is that not only will it pull all the "new" records, but also all the "old" records. I just want to append the records that are not already in the table. Any ideas? I have tried using the primary key, but then it dosnt import any records. There will be say 1850 records. And out of the 1850, 1 would be a new record.

 

[ajetrumpet]

The only problem is that not only will it pull all the "new" records, but also all the "old" records. I just want to append the records that are not already in the table.

Once a record is in a table already, it is not new anymore, it is just part of the mix. So how in the world do you specify to the query that you want only that one record that you just entered??

One solution comes to mind right off, and that is to use the temporary table process that I posted in a sample database. If you house newly entered records in a temporary table, then you know exacly which ones are new (based on the current data entry session), and you can identify them without having Access sift through the other 1850 of them.

You might want to give it a look see....

http://www.access-programmers.co.uk/forums/showthread.php?p=636636#post636636

 

[Needhlp]

You may want to try this

I have had the same problem.

What I do now. I "get external data" from Excel 3 x weekly from a live report. Therefore, the data sometimes overlap.

I create a table for each day. I remove primary keys from parent and child tables. I create an Append Query and never save it.

Once the daily spreadsheet are appended to the main table, I create a duplicate query. The duplicate query will tell you exactly if you have duplicates and you only have to delete the duplicated reports. No fuss!

Hope it helps