Partial Entry in a Database Search Field

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

Guest

Is it possible to set the search field to return results for a partial entry?
For example, in searching for the last name Johnson, instead of having to
type in Johnson, typing in Joh would return all of the Johnsons (I know it
would also return other names that start with Joh). The challenge I'm facing
is that I have some Jr.s and Sr.s and unless the person searching types in
Johnson Jr. or Johnson Sr., they are not seeing them in the results. Thanks.
 
use Like instead of = in your query

--




| Is it possible to set the search field to return results for a partial entry?
| For example, in searching for the last name Johnson, instead of having to
| type in Johnson, typing in Joh would return all of the Johnsons (I know it
| would also return other names that start with Joh). The challenge I'm facing
| is that I have some Jr.s and Sr.s and unless the person searching types in
| Johnson Jr. or Johnson Sr., they are not seeing them in the results. Thanks.
 
I tried that but it didn't work. Johnson Jr. still does not come up when you
type just Johnson into the Search field. I tried editing the field itself by
setting the data value to Field Must be Less Than or Equal to (fieldname) as
well as Greater Than or Equal to but that didn't work either.
 
Lets see your SQL.
MikeR said:
I tried that but it didn't work. Johnson Jr. still does not come up when you
type just Johnson into the Search field. I tried editing the field itself by
setting the data value to Field Must be Less Than or Equal to (fieldname) as
well as Greater Than or Equal to but that didn't work either.

:
Click to expand...
 
Back
Top