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 09:12:59 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?
Summary: Ho Ho Ho! I am having trouble with getting a certain calculation. Presently, I have a table with the following columns: Time, TagNo, and Status. Time is in typical hh:mm:ss format (but a text field bu...
Summary: I have an Access table with 1600 records in it. What I want to do is be able to count how many records there are of a certain type. For example I have 6 different entries in a genre field. Rock, Co...
Summary: Make an append query first that takes all the records from the current table filtered a value less than or equal to desired selected date. We'll call that Query 1. Use that append query to paste the r...
0 
How to lock a shared file
