If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Unique Records- query as duplicates - Access 2002
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 |
#2
|
|||
|
|||
Unique Records- query as duplicates - Access 2002
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" wrote in message ... 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 |
#3
|
|||
|
|||
Unique Records- query as duplicates - Access 2002
Thanks Roger, I will have to find a work around for this.
"Roger Carlson" wrote: 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" wrote in message ... 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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
access 2003 select query closes access | Keith G Hicks | Running & Setting Up Queries | 1 | July 6th, 2004 08:14 AM |
Access 2003 / Visio 2002 Conflict | SP | General Discussion | 0 | June 23rd, 2004 05:02 AM |
Count Unique Values with sorting and filtering by pop-up form | Yanick | Setting Up & Running Reports | 8 | June 4th, 2004 12:51 PM |
query field reference help | -dch | Running & Setting Up Queries | 4 | June 2nd, 2004 07:30 PM |
Access Query returns no records in MailMerge | Joe Brazell | Mailmerge | 4 | May 12th, 2004 09:51 PM |