I’ve been asked if I can create a report to list possible duplicates for checking. The database has over 70,000 records.
My thoughts is having filter options the user can turn on or off like surnames have to match and/or first names.
Other filters might be email match or address match etc.
When the filters are selected I envisage a list appearing determined by the filters selected.
For example, you might want to check the data using first name, surname and email match. You might then get:
Any help getting started with this would be much appreciated.