I created a query "Find Duplicates" with the wizard.
It finds duplicates, exactly what I'm looking for but it also finds duplicates for records that have no value in that field. Not sure why it returns those records. I have hundreds of records with blank values in that field but it seems to pick out a few. I check those records and don't know why it would be returning that record.
Has anyone encountered this?
It finds duplicates, exactly what I'm looking for but it also finds duplicates for records that have no value in that field. Not sure why it returns those records. I have hundreds of records with blank values in that field but it seems to pick out a few. I check those records and don't know why it would be returning that record.
Has anyone encountered this?