DavidDF1913
asked on
Access 2003 Select Distinct in Append Query
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?
Example:
Insert into Master (Last,first... )
Select Distinct Daily1.last,Daily1.first ...
[plus other fields (address,city,state) ]
From Daily1
Thanks,
David
My question is how do I limit Select Distinct so the other fields which are part of the same record are also updated?
Example:
Insert into Master (Last,first... )
Select Distinct Daily1.last,Daily1.first ...
[plus other fields (address,city,state) ]
From Daily1
Thanks,
David
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.