Unique Records- query as duplicates - Access 2002

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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

Ray said:
Hello All, When I query a table for duplicate records I get two records
Click to expand...
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.
 
Back
Top