Full And Partial Matching

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
 
K

KARL DEWEY

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

Template with fields and premade texts.. 0
Partial match 1
Partial match Join query 3
Word macro that can call cells out of Excel for a find and replace 0
Solved Disk Full error message when exporting PDF 0
Create if partial match then copy and paste data from one cell to another 1
Matching literal text "???" in Word 2010 field code IF statement 2
Partial Match query design 3

Top