I have a database of birds. One of the fields is a text field called "Colors". I have a query for that field asking for the colors of the bird I am trying to identify. For example the colors in that field might be "black, white". If, in the query I ask for colors "white, black" it returns with no finds because the entered colors were "black, white". I am trying to do 2 things - fix the field so it doesn't matter if I enter "white, black" or "black, white" and returns forms that ONLY contain "black, white". Is this possible??
Spur52