Partial Match Results in Query

[Guest]

I am trying to set up a database to manage my boss's contact list. I set up a
parameter query to search by last name and return results. Yet, I want to be
able to type in a partial last name and return all the results that contain
say the latters "ca". How do I do it?

 

[Dirk Goldgar]

I am trying to set up a database to manage my boss's contact list. I
set up a parameter query to search by last name and return results.
Yet, I want to be able to type in a partial last name and return all
the results that contain say the latters "ca". How do I do it?

Something like:

SELECT Contacts.*
FROM Contacts
WHERE Contacts.LastName
Like "*" & [Enter last name, or part of it] & "*";