Multiple field search based on a qry - Wildcard required 1

[NWildblood]

This is probably childs play - I have a query that searches names from three different name fields in table InformationContact

______________
SELECT *
FROM InformationContact
WHERE [Enter Contact Name]=[Contact Name #1] Or [Enter Contact Name]=[Contact Name #2] Or [Enter Contact Name]=[Contact Name #3]

_______________

Can anyone advise how to use a wildcard so the name being searched for doesn't have to be complete ? E.g. just search by "Smith", instead of "Mrs Margaret J Smith" ?

Thanks !

"No-one got everything done by Friday except Robinson Crusoe...

 

[PHV]

WHERE [Contact Name #1] Like '*' & [Enter Contact Name] & '*'
OR [Contact Name #2] Like '*' & [Enter Contact Name] & '*'
OR [Contact Name #3] Like '*' & [Enter Contact Name] & '*'

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[NWildblood]

Thanks PHV, perfect - I really appreciate your swift reply !

"No-one got everything done by Friday except Robinson Crusoe...