Full And Partial Matching

  • Thread starter Thread starter Ahliank
  • Start date Start date
A

Ahliank

Hi All,

I have a query that I am trying to use to return names and addresses that
match partial(match half or more character)or full to another field. And
maybe i need function to remove the special character from the field (eg:
Comma)

Thanks in advance for your help
 
You can remove spaces, commas, dashes like this --
Clean_Field: Replace(Replace(Replace([YourField], " ", ""), ",",""), "-","")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Partial match Join query 3
Access Partially match 2 lists 1
Partial Match query design 3
Identifying partial string matches 2
Help with a partial match query 6
Index with partial text 1
With F1 value, look at A, if match or partial match return B 5
Show all of one tbl and partial match from another tbl 4

Back
Top