Partial match

[Ahliank]

Hi All,

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

Thanks in advance for your help

 

[Joseph Meehan]

Could you provide some examples and what "special character." What
version of Access are you using?

Also it might be best to post your question in an "Access" group rather
than the more general Office group.