Filters in a query

[Guest]

I have a database that has two drop down lists - one for employees, and
another for a group. I also have a checkbox that is checked whenever
correspondence meets certain criteria. What I would like to do is to have ONE
filter/query that is the same for ALL the groups (all Admins use the same
database) where the Admin simply chooses their group from a drop down list
and the query includes only the correspondence that meets the checked
criteria. The final query would look something like this:

1) Operations Group (name of the group selected from drop down)
2) All correspondence received from the Electrical Division (this is the
checked box) No other correspondence would show
3) Date received
4) hyperlink field that is connected to the PDF of that specific document

Is there a way to do this??

 

[Guest]

There is a way to build the query on the form when the Admins finish entering
their data based on selected controls. If you need help writing the query,
please provide the structure for your tables. What happens when your final
query executes? Do you want the results returned to a form/subform or report?

 

[Guest]

If possible, I would like the Query to show in a report. Again, using this
example (please go easy on me, I am an Access Novice) can you tell me how to
set this up?

Operations Group (name of the group selected from drop down)