Unanswered: Append Query to append only distinct records
I would like to add values to one table based on entries in another table. However, if a combination of field1 and field2 already exist in the first table, I would not like to add that record. I have tried to do an append query with a NOT IN subselect, but it doesn't seem to be the right approach. Can anyone give me guidance on this?