![]() ![]() Place some dedicated fields from the record in the portal to recognize the data. NameLast & “ “ & Right(telephoneNumber 4)Īnd you need a self join relationship sameRecord_cti = sameRecord_cti.īy placing the portal based upon this relationship on a layout you can ‘see’ all the duplicates and also the possible similar records. Left(nameFirst 1) & “ “ & “ “ & nameLast & “¶” & NameFirst & “ “ & Left(nameLast 3) & “¶” & You need a ‘sameRecord_cti’ (_cti = calculated, text, indexed) field, this will be based on several criteria, each separated by a carriage return. I don’t know your file nor fields, so I use some dummy fields. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |