I believe this is a simple quetion, but I can't wrap my head around it.
I have two tables with identical structure. TBL1 and TBL2...Each table has 4 fields. . I want to use an append query to insert the contents of TB2 into TB1, however I only want to insert those records that are unique based on all 4 fields. The fields wil all have duplicate data, however the combination of all 4 fileds makes them unique.
I know I can combine all four fiields into a unique "key", however I think there is a means of inserting only distinct rows...however I can't seem to construct such a query in the MS Access query builder.