Query results

[Sean]

I'm trying to get the criteria in my query to produce a form that shows a
list by customer. Say my customer name is ralph but it might have different
offices so in our customer database we might have ralph-windsor or
ralph-london. I want them to be able to type in "ralp" and get any customer
with "ralp" in it. I've tried a few "like" option with different wildcards
but I can't get quite the right results. I figure this one should be pretty
easy.

Thanks.

 

[KARL DEWEY]

Like [Enter start of search] & "*"
or
Like "*" & [Enter start of search] & "*"

 

[ldiaz]

just type *ralp*

or use this in your query:
WHERE (((tableName.FieldName) Like "*ralp*"));



Thanks
LD