Query Lookup

[Daniel]

Hello,

I have a query that prompts for criteria for a site description from a
sitelog table. The query works fine and does what it is supposed to. Some
of my sites are like this:

Hospital
School
School / Hospital

The site descriptions are selected from a combobox and are limited to list.

My problem is, that I need the query to show both School and School /
Hospital when the criteria that is entered is School, and when Hospital is
entered for the criteria, it shows Hospital and School / Hospital. I have
many others like this, but these are just for examples. I don't want the
user to have to run seperate queries to view all the Schools, because the
Schools could also be like School / Sports & Recreational.

How can this be done if at all. Any help would be appreciated.

Thank You,

Daniel

 

[tom]

If your criteria is simply pointing to the value of the combobox, then it is
working as it should be. You should enter the word Like at the beginning and
an asterisk * text string at the end.

HTH.

Tom.