I need a query to display only black colored dogs names. how do i.

[Guest]

i have a table of dogs and their colors. i need a query showing only the dogs
names of those who have a black color in their color. There are a few
different colors but Of the colors listed some say black and another color,
and some say black only. I am having trouble figuring out how to display this
in the query search.

 

[Rick B]

like "*" & "black" & "*"

 

[Guest]

Hi, You can use the wildcard asterisk * characters in your query criteria.
In the criteria box for color, type *black* and you'll get all the records
that contain the word black.

 

[Duane Hookom]

I assume you know the basics of queries. You can set a criteria on the color
field of:
Like "*black*"

 

[Rick B]

Note, if you want to prompt the user for the color, you'd use sytax like I
posted earlier (I was not thinking straight and made it harder than
needed...

To prompt the user and find the string anywhere in the field, use...

Like "*"&[Enter Colr]&"*"

If hard-coded, then the other answers you got are easier.


Rick B