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
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
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
Summary: Hello All, I work as a programmer for a direct mail company. Here is my problem: I am developing a Access (.mdb) database for a company that we just mailed tax forms for to there customers. The com...
Summary: I'm trying to program an access query so that people can enter a database and 2x click the query to receive an input box for the search term. So far I have [Enter company name preceded and followed by...
Summary: I have an Access query (Qry2) that I need to update data in a table (Tbl3). Ory2 is pulling data from another query (Qry1). Qry1 is calculating data from Tbl1 and Tbl2. Okay, so the data shows up f...
0 
MySQL backup - move file ...
