CAN I FILTER A QUERY AND THEN RUN A REPORT ON THE FILTERED RESULTS

[Guest]

I have been using Access2007. I have a list of queries that I would like to
be able to filter, and then get a report based on the filter.

When I manually highlight a given field in a table and hit the filter
button, it shows all of the options to filter by, and lets me check mark the
ones I want included and then reflects the changes. I would like to have
something similar (with check boxes) but built into a form of some sort for a
more personalized look and feel.

Right now, I have to recreate a report every time I want to filter something
and it's just a pain!

Does anybody have any ideas or suggestions?

Thanks!
Bryan

 

[Ken Snell \(MVP\)]

I have a sample database that shows how you can set up a form to allow you
to filter any/all of various fields for a report:
http://www.cadellsoftware.org/SampleDBs.htm#FilterForm

This should give you some ideas.