return everything that contain a specified word

[Rodolfo Fontes]

Hi group,

How can I make a query that return everything that contain part of a
criteiria?
Example:
I want to get all the names from the table employes that have the
letter "a" on it.

Thanks,
Rodolfo Fontes

 

[Rick Brandt]

Hi group,

How can I make a query that return everything that contain part of a
criteiria?
Example:
I want to get all the names from the table employes that have the
letter "a" on it.

Like "*a*"

 

[Joan Wild]

Like "*a*"

Rick meant
Like "*a*"
or you could use
Like "*" & [Enter letter] & "*"
to get a prompt for the letter.

 

[Rick Brandt]

Like "*a*"

Rick meant
Like "*a*"
or you could use
Like "*" & [Enter letter] & "*"
to get a prompt for the letter.

Am I missing something? It looks like what I meant is the same as I what I
wrote

 

[Joan Wild]

Like "*a*"

Rick meant
Like "*a*"
or you could use
Like "*" & [Enter letter] & "*"
to get a prompt for the letter.

Am I missing something? It looks like what I meant is the same as I
what I wrote

That's weird. When I read it in OE, I see your text as
Like "a"
And now mine looks like that as well...???