return everything that contain a specified word

  • Thread starter Thread starter Rodolfo Fontes
  • Start date Start date
R

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
 
Rodolfo Fontes said:
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.
Click to expand...

Like "*a*"
 
Rick said:
Joan Wild said:
Rick said:
Like "*a*"
Click to expand...
Rick meant
Like "*a*"
or you could use
Like "*" & [Enter letter] & "*"
to get a prompt for the letter.
Click to expand...

Am I missing something? It looks like what I meant is the same as I
what I wrote :-)
Click to expand...

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