Append Query Criteria

[flhr0175]

Hello,

I have an append query that I want to append all the new records. I have it working if I use the criteria of today's date but I want to use the ID field to only append any records that are not already in the table.

Is that possible without writing code?

 

[cyanidem]

Use "Query Wizard" from ribbon, then "Find Unmatched Query Wizard" and follow it, result of this is what you'll want to append.

 

[flhr0175]

that works great but that just tells me what I need to append. it doesn't change the criteria so if the append query is run more than once it doesn't duplicate the records.

 

[flhr0175]

I solved this problem by indexing the ID field in the main table and not allowing duplicates.

New Issue - in my testing, I updated the linked table that the append query grabs it's information from. When I click "View" it brings up all the other information that put in this morning but not the new items I put in as test items.

 

[jdraw]

You will probably learn more about database concepts that will help you with your database by working through this tutorial. You have to work through the process to get the benefits, but you will learn.
It starts with a problem statement and then goes through a process to design the database to meet the requirements. Takes about 30-45 minutes). It does contain a solution.

good luck.