Filter data in the report

[Starmo]

Hello peoples!
I have one problem that I do not know how to solve it.


Here's what it's about. I have one query in which one column serves to select rows (yes / no). Based on that query I made a report.
Interested in how to select data in the report. (Yes / no).
I would like to make three buttons. On one i would put "show active yes", on the second "show inactive no" and on the third "show all".
Or maybe on a combo box put these three options?

[Minty]

Generally you would do the filtering in the query, then base the report from that.
Reports aren't really designed to be "active", they format their data based on a record source, then present it.

Requerying the report would require the underlying query or the filter applied on opening the report to be reset.

[Starmo]

Generally you would do the filtering in the query, then base the report from that.
Reports aren't really designed to be "active", they format their data based on a record source, then present it.

Requerying the report would require the underlying query or the filter applied on opening the report to be reset.

Yes, I understand you. As I wrote, I have a query through which I can filter it. Each time I want to see it in a report, I must first go to the query and set it up, and then open the report again.
I thought if it could be somehow simplified.
How would you do it?

[Minty]

You can use a form to pass a parameter to the query, so if your form was called frmReports and your criteria was a yes/no check box called chkActive your would use

[Forms]![frmReports]![chkActive]  Or [Forms]![frmReports]![chkActive] Is Null

in the criteria section of the query builder to make it look for that value on your form. This format allows a null value to return all the results.