searching for names and parts of name using queries

H

Helen55

I am trying to set up a query where the user is prompted for the Name -
however I not only want the name to appear I also want to be able to retrieve
results that contain part of the word in the search as well
 
R

RonaldoOneNil

if you are doing it via a prompt then set your criteria to
Like "*" & [Enter Full or Part of Name] & "*"

If you are doing it via a textbox on a form then enter your criteria as
Like "*" & Forms![FormName]![TextBoxName] & "*"
 

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

Crating User Form to Add Names 1
Insert name and adress from a list in a word document 1
Grouping Names in Mail Merge 0
Sharepoint not capturing staff name when automation runs 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Document Merge Formatting Issue 0
Dynamic Naming of Form Button 3
Outlook - Catgorizing emails by names 0

Top