StaciLangford
MIS
Hi. I am creating a report from a really messy database. There has been a lot of entry error resulting in duplicate records. I have been able to remove the exact duplicate records, but now I'm not sure how to get rid of the records that are off by a character or two due to mistyping (example: Mellisa Smith v. Meillisa Smith v. Melissa Smith). I don't need to remove them from the database - I just need them to not show up in the report.
Is there a way to do this?
Thank you in advance for your help,
Staci
Is there a way to do this?
Thank you in advance for your help,
Staci