Can I filter a query by a drop-down list, then run the report on i

[Bryan]

I have one large table with many clients information stored inside. I would
like to be able to filter through a query by drop-down lists to include which
clients and info I want included on the report.

Ideally, I would be able to "Select All", or have check box's that would
allow me to select multiple single clients at once.

I would like to filter 3 or 4 different fields. If it is possible to do the
above, once I select the Client, would it then only show me that clients info
in the next filter field, and so on? That would be perfect if it would
eliminate any info in the query that does not pertain to the previous filter
so the person filtering doesn't get confused.

I am a rookie at this, so hopefully I have explained it well enough....

Thank you very much!
Bryan

 

[Allen Browne]

See:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html

You can download the sample database application, pull it apart, and see how
the create the Filter string.