Hi,
I am having a problem with the 'Find Duplicates Query Wizard' in Access 2007. The wizard does not seem to be matching blank fields as duplicates.
For example
"NAME", "DOB", "MARKS", "GRADE"
"John Smith", "9/1/1984", "92", ""
"John Smith", "9/1/1984", "92", ""
is not considered as a duplicate whereas
For example
"NAME", "DOB", "MARKS", "GRADE"
"John Smith", "9/1/1984", "92", "A"
"John Smith", "9/1/1984", "92", "A"
is considered a duplicate.
Why does this happen? And is there a way to get around this problem?