Easy question for you guys

[wjmjr]

I need some quick help

I have a db with multiple tables. I have 15 queries that look up open audit obsrevations depending on the name.
I'm trying to limit the number of queries that I need to validate. Is there a way to create one query that has a lookup fied or Key word field.

Thanks in advance

-WM

 

[wjmjr]

Pat
I used you first option it works great but I have one more issue...
The field I'm looking up is a name field. When I enter a value ie (Warner) I get all the audit observations. (perfect)
However some observations are given to multiple people ie (Warner/Cinder). When I run the query I'm missing the rows which contain multiple names.
Can I use a wild card character or
Select...From... Where SomeField = [enter a value] [ / ] to get all the values

-WM