buzzer
02-11-2002, 10:09 AM
I want to deduplicate an address file against itself using the first five letters of the company name, and the postcode, any ideas ?
|
View Full Version : Deduplication based on a partial field and Postcode fields buzzer 02-11-2002, 10:09 AM I want to deduplicate an address file against itself using the first five letters of the company name, and the postcode, any ideas ? David R 02-11-2002, 10:18 AM I believe you can use the Find Duplicates Query for this, you'll have to make a calculated field query first with the XXXXX<postcode> stuff you want. Sorry, initially typed that as US Post code...you get the idea. Does that help? David R [This message has been edited by David R (edited 02-11-2002).] |