There are two possible approaches here:
a) Put a parameter in the query, so it pops up a box for each of the
criteria.
b) Create a form where the user can enter the criteria, and click a button
to open the report so it is filtered.
There are lots of disadvantages with (a), e.g.:
- no range checking,
- asks the user for every one of the criteria whether they want to use them
or not.
- no drop-down list (unless you do a kind of (a) + (b) comination.)
For an example of how to do both, see:
Limiting a Report to a Date Range
at:
http://allenbrowne.com/casu-08.html
Another very simple example of (b):
Print the record in the form
at:
http://allenbrowne.com/casu-15.html
A more complex example:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html
(The "Trouble-shooting and Extending" section of this article explains how
to pass it on from the search form to the report.)
Hope that sets you on a useful path.
