Partial Match Results in Query

A

ALoecher

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?
 
D

Dirk Goldgar

ALoecher said:
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?
Click to expand...

Something like:

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