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
|
|||
|
|||
"Fuzzy" Query
Hi, I have two large tables that need to be combined, Original and 01_16.
The two fields in question are Original.Company.Name and 01_16.BusinessName. 01_16 has the data that needs to be added to the records in Original where the above tweo fields are the same. The problem is that only 7 records in both table shave the exact same name. 01_16 has the same companies but whoever created the table gave the companies slightly different names when he should not have done so. Is it possible to create a query using the original.CompanyName field with a criteria of like *[01_16].[BusinessName]* ?? I hope I am getting across what I need. I want the query to bring back, as an example, from the table Original a company named Target Corporation but I want the data from 01_16 to come back if there is a Business named Target Stores or Joe's Target House. Thanks. Win XP Professional, office 2003 |
#2
|
|||
|
|||
There is nothing built in that would do this.
You would need some fairly complex code to even try. IF you have a limited number of CompanyName and BusinessNames then you could create a linking table with the equivalents and use that in a join. TblMatches OriginalName MatchName Andy wrote: Hi, I have two large tables that need to be combined, Original and 01_16. The two fields in question are Original.Company.Name and 01_16.BusinessName. 01_16 has the data that needs to be added to the records in Original where the above tweo fields are the same. The problem is that only 7 records in both table shave the exact same name. 01_16 has the same companies but whoever created the table gave the companies slightly different names when he should not have done so. Is it possible to create a query using the original.CompanyName field with a criteria of like *[01_16].[BusinessName]* ?? I hope I am getting across what I need. I want the query to bring back, as an example, from the table Original a company named Target Corporation but I want the data from 01_16 to come back if there is a Business named Target Stores or Joe's Target House. Thanks. Win XP Professional, office 2003 |
#3
|
|||
|
|||
You might have some other piece of data which would be more consistant. Do
both tables contain phone numbers? Linda "Andy" wrote in message ... Hi, I have two large tables that need to be combined, Original and 01_16. The two fields in question are Original.Company.Name and 01_16.BusinessName. 01_16 has the data that needs to be added to the records in Original where the above tweo fields are the same. The problem is that only 7 records in both table shave the exact same name. 01_16 has the same companies but whoever created the table gave the companies slightly different names when he should not have done so. Is it possible to create a query using the original.CompanyName field with a criteria of like *[01_16].[BusinessName]* ?? I hope I am getting across what I need. I want the query to bring back, as an example, from the table Original a company named Target Corporation but I want the data from 01_16 to come back if there is a Business named Target Stores or Joe's Target House. Thanks. Win XP Professional, office 2003 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
SQL query showing diff between actual and budget | Bon | Running & Setting Up Queries | 3 | August 25th, 2005 12:07 PM |
Nested in-line Query | laura | Running & Setting Up Queries | 0 | February 11th, 2005 12:17 AM |
Here's a shocker | Mike Labosh | General Discussion | 2 | October 26th, 2004 05:04 PM |
Big number gives error! | Sara Mellen | Running & Setting Up Queries | 8 | October 11th, 2004 02:48 AM |
Display Parameter from Form on Report | sara | Setting Up & Running Reports | 10 | July 19th, 2004 04:54 PM |