Query argument for a partial field!

[JHB]

Hi:

I wish to construct a query that does a search on a field in a table
for a set of characters. In other words, looking for the name
Bumblebridge, I would like to be asked for "part of the name", enter
"bridge" and find all the records with bridge in the name.

I have constructed a query criteria that looks like this:

like [Enter part of the name] & "*"

This finds all the records with "bridge" at the beginning of the name!

However when I create a criteria designed to find bridge anywhere in
the field, I run into trouble:

"*" & like [Enter part of the name] & "*"

is considered to be an error, and it wont execute.

Can someone tell me what I am doing wrong please?

Thanks in advance.

John Baker

 

[SteveM]

Try this:
Like "*" & [Enter part of the name] & "*"

Steve

 

[SteveM]

Try this:

Like "*" & [Enter part of name] & "*"

Steve