Finding any part of a field using queries

[zach028]

I have a query (linked to a command button on a form) that is supposed to search a table for a name value. Because the names are either "FirstName MI LastName" or "LastName, FirstName", I need to search for the value in any part of the field. My criteria looks like this:

Like "* Forms![Account Number Search]![Text8] *"

Text8 is the field where the user inputs the last name.

I continually get no return value, even when I input the exact field. Please help!

 

[MissyEd]

Hi there

It looks like your criteria is not set correctly. If you use: Like "* Forms![Account Number Search]![Text8] *"
I think it sees the exact sentence above. Maybe you could try: Like "*" & Forms![Account Number Search]![Text8] & "*"

Let me know if this works ! Missy Ed
Looking to exchange ideas and tips on VB and MS Access development as well as office 97 development. Drop me a line: msedbbw@hotmail.com

 

[gtobey]

I have used this syntax to obtain receords if the search string is contained in any part of the field Mod:
Like "*" & [Mod?] & "*"

 

[zach028]

It worked like a charm, Missy. Thanks!