Finding duplicates & parsing strings

[tyemm]

I am looking for potential duplicate records in a table. A duplicate would have the same LastName and IDNo, but there might be duplicates where an IDNo had leading zeroes, thus: 05887 and 5887 are really duplicates.
I've tried running the find duplicates wizard on Table1 with fields LastName and IDNo, and then trying a Right([Table1].[IDNo],4) in my duplicate criteria, but it is not working. Is there not a simple way to do this?

 

[genomon]

If they are always numbers stored as text, try using CInt([Table1].[IDNo]) or CLng([Table1].[IDNo]).

Sure, the early bird gets the worm, but the second mouse gets the cheese in the trap.