in a query for only black colored dogs in a created table how do .

[Guest]

i have a table listing dogs and thier colors. I need to make a query to find
only the dogs with black as one of thier colors as some dogs are listed as
having more then one color. I am having trouble finding out how to define my
search in the query.

 

[John Vinson]

i have a table listing dogs and thier colors. I need to make a query to find
only the dogs with black as one of thier colors as some dogs are listed as
having more then one color. I am having trouble finding out how to define my
search in the query.

If the color is stored in a text field (e.g. "White with black paws",
"Black and white", "Red, black and tan") then a criterion of

LIKE "*black*"

should work. The * wildcard matches any string of zero or more
characters.

For a more flexible parameter query which prompts the user for a
color, try

LIKE "*" & [Enter color:] & "*"


John W. Vinson[MVP]