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

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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.
--

Ken Snell
<MS ACCESS MVP>




"Bryan" <Bryan@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2FBC1C0E-42F0-420D-827C-B1CE5933560C@xxxxxxxxxxxxxxxx
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


.

Quantcast