Query to find Part of the Name

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If I have a query that looks like
[=CANDIDATE]
and I am searching for John, but there are john Doe, John Dillon, and John
Chronos,
I would like the search to bring back all of the record with John in them.
If I inputted John D I would like for it to return John Doe and John Dillion,
but not John Chronos.

Thanks
 
Do you mean =[CANDIDATE]?

You want to use: LIKE "*" & [Partial Name of Candidate] & "*" as the
Criteria for the Candidate field (presumably a field in your table?)

Good Luck!
 
Excellent! Thanks Much!

Chaim said:
Do you mean =[CANDIDATE]?

You want to use: LIKE "*" & [Partial Name of Candidate] & "*" as the
Criteria for the Candidate field (presumably a field in your table?)

Good Luck!
--
Chaim


Rod said:
If I have a query that looks like
[=CANDIDATE]
and I am searching for John, but there are john Doe, John Dillon, and John
Chronos,
I would like the search to bring back all of the record with John in them.
If I inputted John D I would like for it to return John Doe and John Dillion,
but not John Chronos.

Thanks
Click to expand...
Click to expand...
 
Back
Top