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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Remove duplicates and mark field in master record
I think I am confusing the subject. I have 15 tables all identical in layout. They all contain Mailing addresses with a layout like this. List_ID,Fname,Lname,Title,Firm,Address,city,st,zip,Phone,Email Some records might have a firm, others wont same with title email and phone. I want to create a...- parksjsn
- Post #6
- Forum: Microsoft: Access Tables and Relationships
-
Remove duplicates and mark field in master record
The Database is to large to send very quickly,the tables are essentially the same, they are for a mailing list. The fields are the same in all tables, fname,lname,add1,add2,city,st,zip,zip+4 etc. The list is owned by one company but the tables are specific to branch locations. The problem is...- parksjsn
- Post #3
- Forum: Microsoft: Access Tables and Relationships
-
Remove duplicates and mark field in master record
I have a database with 15 tables(aprox) I have combined all tables into one tabe and assigned a separate primary key prefix for each original table. Is it possible to create a query that would search for duplicates and remove duplicates based on name and address and also add a character to a...- parksjsn
- Thread
- Replies: 5
- Forum: Microsoft: Access Tables and Relationships
