Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft access training - Fuzzy matches to a look-up table
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
microsoft access training - Fuzzy matches to a look-up table
Resolved · Low Priority · Version Standard
Reply Thu 5 Jul 2007, 17:14Delegate Richard said...
Richard has attended:
Access Advanced course
Fuzzy matches to a look-up table
I have a table of contacts where one of the fields is Job Title. I also have a look-up table that contains a list of job titles.
I would like to know how I can pull all of the contacts that have a match to the job title field in the look-up table. An exact match is easy, I can just create a query and link the two fields.
I would like to know if I can pull all contacts that has a 'contains' match. So if one of the job titles in look-up table is analyst, the search would also find data analyst.
I could enter in the criteria section of the query *analyst* which would find data analyst, but I have over 100 job titles in the look-up table that I would have to manually enter.
Is there a way of running a contains across these job titles?
Thanks
For upcoming training course dates see: Pricing & availability
RE: Fuzzy matches to a look-up table
try this article.
http://technet.microsoft.com/en-us/library/ms137786.aspx
|