Unique Records- query as duplicates - Access 2002

[Ray]

Hello All, When I query a table for duplicate records I get two records that are very similar but are not the same as duplicates. is there a way to fix this? these are the PartID's I query that are showing duplicates but as you can see they are not really duplicates.
F3N400x10-CUST
F3N400X10-CUST
R6G088aR-25
R6G088AR-25

Thanks in advance.
Ray

 

[Roger Carlson]

As far as Access is concerned, these ARE duplicates. Access is case
insensitive.

--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org

Hello All, When I query a table for duplicate records I get two records

that are very similar but are not the same as duplicates. is there a way to
fix this? these are the PartID's I query that are showing duplicates but as
you can see they are not really duplicates.