Donna said:
I am trying to filter a database that tracks Work Procedures. I to have the
query ask which unit or units they are looking for.
you can add a parameter to it, but you can only specify a single
match... well, unless you throw in an OR clause. The most flexible way
is to use a form to collect criteria and then open a report based on
the query and filter in the Open event of the report.
otherwise, you'd have to modify the WHERE clause of the query on the
fly using VB.
