Access 2003 Select Distinct in Append Query
Posted on 2004-08-16
I am appending table 'A' to table 'B'. Both tables have a very simular structure. The group of fields last,first & init have a unique value. If this unique group is not present in table 'B' these fields, along with several other non-unique fields, should be added to table 'B'.
My question is how do I limit Select Distinct so the other fields which are part of the same record are also updated?
Insert into Master (Last,first... )
Select Distinct Daily1.last,Daily1.first ...
[plus other fields (address,city,state) ]