access 2016 Add request without duplicates

[bip54]

Hello, After several months my little and very simple database of Cookbooks on Access 2016 has made good progress; for the use that I have, I have only one point to solve (I think):




I have a table "tNew_Books" without index with two fields Short text namely "Titles" and "Subject"; I created a simple addition query "rAdd_New_Books" which copies the contents of these two fields into a table "tBooks" also without index and which contains the same two fields "Titles" and "Subject". I do not know how to prevent the query from copying Titles from the "New Books" table that are already in the "Books" table; I have to rely on the strings that make up the titles to differentiate them because I do not want to add an index, it would be too complicated for me because I should take other things in my database ... I would prefer to add a condition in the query Add


Thank you for your help .

[ranman256]

make a query Q1, that shows all title/subjs in tBooks,
then make Q2, bring in tNew and Q1 into the query. You want to say,'show me the books in tNew that are NOT in Q1'
join the title/subj fields
dbl-click the join lines and set an OUTER join. Set ALL books in Q1, some in tNew
bring down tNew.Title, tNew.Subj, tBooks.Title, tBooks.Subj
set criteria, set tBooks.Title is null

this says show me all tNew books not in tBooks.
make an append query ,Q3. BRing in Q2, add the missing items to tBooks.

[bip54]

Wow, quick and efficient !
Many thanks