Finding Similar Text ?

[Guest]

My table contains a text field called "Company_Name".

As the name idicates it holds a text value of a name however, it contains
names that may be the same company written a different way.

Example:
"Chicago" vs. "Chicago, City of"

What I need to do find a method to pull these similar records based on the
first 5-6 characters so that all records with the same first 5-6 letter
letters are returned.

Thanks,
JCrowe

 

[Guest]

You can use Like with a wild card

In the query under the Company_Name field write the criteria

Like [Please enter company name] & "*"
will return all the records that start with the string entered

Like "*" & [Please enter company name]
will return all the records that end with the string entered (any where)

Like "*" & [Please enter company name] & "*"
will return all the records that contain the string entered