Find Record Action

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

Guest

Hello! I am hoping one of you lovely, helpful people can assist me.

I have a query in access that I've created to search for a name. The
criteria I am using is just [A-Z]. This way the user is prompted to enter an
exact name to search for. This is working well except I am really trying to
get it so that it will search by any part of field. ie. "jo" will pull John,
Joe, & Joanna.

I can only find this option in the Macro section & I still cannot leave that
as a miscellaneous or wildcard field.

Essentially I have a form, where the user will just enter a portion of
someone's name & be able to pull all records containing that portion.

Is this possible?

Thanks in Advance!!
 
Use this as criteria when entering the start of the name --
Like [Enter start of name] & "*"

To pull records by entering any part use this --
Like "*" & [Enter any part of name] & "*"
 
Thank you Sooooooo much!! You Rule!

I've been entering this stuff in to the help sections for the past few days.
Plus I've thumbed through 2 separate books...
:o)


KARL DEWEY said:
Use this as criteria when entering the start of the name --
Like [Enter start of name] & "*"

To pull records by entering any part use this --
Like "*" & [Enter any part of name] & "*"

jules said:
Hello! I am hoping one of you lovely, helpful people can assist me.

I have a query in access that I've created to search for a name. The
criteria I am using is just [A-Z]. This way the user is prompted to enter an
exact name to search for. This is working well except I am really trying to
get it so that it will search by any part of field. ie. "jo" will pull John,
Joe, & Joanna.

I can only find this option in the Macro section & I still cannot leave that
as a miscellaneous or wildcard field.

Essentially I have a form, where the user will just enter a portion of
someone's name & be able to pull all records containing that portion.

Is this possible?

Thanks in Advance!!
Click to expand...
Click to expand...
 
Back
Top