Computing.Net > Forums > Database > Access Query/Find Similar Records

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Access Query/Find Similar Records

Reply to Message Icon

Name: GiveMePatience
Date: February 28, 2007 at 10:51:44 Pacific
OS: xp
CPU/Ram: 1.8ghz/512
Product: ibm thinkpad
Comment:

I'm trying to design a query in Access that will find similar records (not dups). I have two tables with UserIDs. One is the result of a previous query, the other an imported table with UserIDs. The query should compare both tables and identify those where the UserID is the same. My problem is that on one table I have UserIDs, while on the other I have UserIds (plus names). Ex: table1 UserID = SSMITH and table2 UserID = SSMITH (Steve Smith). How do I get Access to ignore the info in parens without having to modify tables?
thx

gmp



Sponsored Link
Ads by Google

Response Number 1
Name: wizard-fred
Date: March 1, 2007 at 02:09:59 Pacific
Reply:

If you don't want to modify table2 then you will have to use a modified search to find the closest match, strip name, then check if there are identical.
If you can modify table2 make field with UserID (minus names) and use it as the field to search against. This should be simpler and faster


0

Response Number 2
Name: GiveMePatience
Date: March 2, 2007 at 13:37:55 Pacific
Reply:

Got it. Thanks!

gmp


0

Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More


MySQL backup - move file ... Hiding VB Code MS Access



Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Database Forum Home


Sponsored links

Ads by Google


Results for: Access Query/Find Similar Records

Access Query to Merge with Word Doc www.computing.net/answers/dbase/access-query-to-merge-with-word-doc/162.html

Access Query Asks For Input Twice www.computing.net/answers/dbase/access-query-asks-for-input-twice/589.html

Access Query question www.computing.net/answers/dbase/access-query-question/606.html