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

Specialty Forums
Security and Virus
General Hardware
CPUs/Overclocking
Networking
Digital Photo/Video
Office Software
PC Gaming
Console Gaming
Programming
Database
Web Development
Digital Home

General Forums
Windows XP
Windows Vista
Windows 95/98
Windows Me
Windows NT
Windows 2000
Win Server 2008
Win Server 2003
Windows 3.1
Linux
PDAs
BeOS
Novell Netware
OpenVMS
Solaris
Disk Op. System
Unix
Mac
OS/2

Drivers
Driver Scan
Driver Forum

Software
Automatic Updates

BIOS Updates

My Computing.Net

Howtos

Site Search

Message Find

Data Recovery

About

Access Query/Find Similar Records

Reply to Message Icon
Original Message
Name: GiveMePatience
Date: February 28, 2007 at 10:51:44 Pacific
Subject: Access Query/Find Similar Records
OS: xp
CPU/Ram: 1.8ghz/512
Model/Manufacturer: 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


Report Offensive Message For Removal

Response Number 1
Name: wizard-fred
Date: March 1, 2007 at 02:09:59 Pacific
Subject: Access Query/Find Similar Records
Reply: (edit)

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


Report Offensive Follow Up For Removal

Response Number 2
Name: GiveMePatience
Date: March 2, 2007 at 13:37:55 Pacific
Subject: Access Query/Find Similar Records
Reply: (edit)

Got it. Thanks!

gmp


Report Offensive Follow Up For Removal







Use following form to reply to current message: 

   Name: From My Computing.Net Settings
 E-Mail: From My Computing.Net Settings

Subject: Access Query/Find Similar Records

Comments:
         

 


  Homepage URL (*): 
Homepage Title (*): 
         Image URL:
 
Data Recovery Software



Yahoo email freeze

Laptop monitor problem?

cannot install new anti-Virs

Monitor Problems

compaq laptop screen is blank

All Posts Awaiting Replies