Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: greenpm959
- Order by date
-
Updating Field where there Dublicates
Is there anyway to update only the dublicates in a field. I have email address that are dublicates and want to add the last 4 digits of the SSN to dublicate only. I writing this for Access data base. I tried: UPDATE Reps SET Email = FirstName + LastName + Mid(SSN,8,4) +'.'+ '@MyCollege.edu'...- greenpm959
- Thread
- Replies: 1
- Forum: Microsoft: Access Other topics
