I would like an option to ignore records without a value for a field(s) when scanning for duplicates.
For example, I generally use the scan for duplicates feature to search our database for records that have the same e-mail address. However, we have a database of around 6,000 records, and quite a few do not have an e-mail address. When I scan for duplicates, I get several hundred records back with most of those being records with a blank e-mail address. I only want to find records that HAVE an e-mail address AND that e-mail address is the same as another record. I do a similar scan on first/last names where I would want to ignore records with blank first or last name.
Ideally, I would like a checkbox for each field in the Scan for Duplicates dialog that would let me chose to ignore blanks (or not) for that field.
I found another idea already posted that requested the ability to scan for duplicates based on a lookup. This would work for me too as I could do a lookup that excluded the blanks, then scan just that lookup.