Re: Query

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: maggie (anonymous_at_discussions.microsoft.com)
Date: 04/01/04 

Date: Wed, 31 Mar 2004 19:26:49 -0800

I don't need an exact match, I can get that to work.
What I need is to find all names that may match.
Example: One name is 'AutoNation' the other name is 'The
Auto Nation'. I need the query to find the match between
the two. I tried using the like function with the name
of the field I want to watch match on but that doesn't
work. Any help would be appreciated.
Thanks.

>-----Original Message-----
>Dear Maggie:
>
>I recommend you do this in separate steps. Bring the
text strings
>into a table first. Then do the matching.
>
>It's not clear whether you need exact matches, or
pattern matching, or
>what. More details on that, please. What is a "similar
string?" Do
>you have an algorithm in mind on which to base this?
>
>Tom Ellison
>Microsoft Access MVP
>Ellison Enterprises - Your One Stop IT Experts
>
>
>On Wed, 31 Mar 2004 13:35:39 -0800, "maggie"
><anonymous@discussions.microsoft.com> wrote:
>
>>Does anyone know how to write a query that would search
>>text strings on an incoming file and compare them to a
>>table that exists on Access. For example, compare name
>>between list of already existing names and list of new
>>names. But the comparison has to not be exact, so that
>>you can search a similar string.
>
>.
>

Relevant Pages

  • Re: How to exclude a string using regexp pattern?
    ... exact output from the Unix grepping tool, ... lots of irrelevant strings ... That part of the regex will match everything up ...
    (comp.lang.java.programmer)
  • Re: Query
    ... Bring the text strings ... Then do the matching. ... It's not clear whether you need exact matches, or pattern matching, or ... For example, compare name ...
    (microsoft.public.access.queries)
  • Re: How do I correctly measure fretboard?
    ... set all strings to be as close as exact to the 12th fet harmonic or some a ... little sharper or others little flatter? ... your setup and action all done first. ...
    (alt.guitar)
  • Re: Losing Accuracy in reading numbers
    ... series of strings in CSV format that are actually numbers. ... the format type but I cant figure out how to convert the exact number. ... Suppose this was a scientific app that required extreme accuarcy in reading ...
    (microsoft.public.dotnet.languages.vb)
  • Re: EXACT formula
    ... Excel Help states that EXACT compares two text strings, ... series of strings. ... Use 5 formulas or VLOOKUP combined with EXACT. ...
    (microsoft.public.excel.misc)