Filter Report in Access 2013

[sashapixie]

Hi

I created a report from a filtered table, however when I unfilter the table this applies the same filter to the report, I have check boxes in the report, what I want to do is filter the report based on the checked boxes, I am new to access, any help would be appreciated.

 

[Joe4]

You're welcome.

Yes, sometimes when making a bunch of changes to Data Sources or underlying fields in a Report, it works better just to rebuild the dang thing!

Glad you got it working.

 

[sashapixie]

I found an alternative route, change the Record Source Name to my query name under the report properties, works a treat and no need to re-format my report

 

[Joe4]

I found an alternative route, change the Record Source Name to my query name under the report properties, works a treat and no need to re-format my report

I apologize, that is what I was implying when I asked if you changed the Data Source in your Report. I probably should have described it in more detail what that actually entails, and not assumed that you knew what I was talking about.

 

[sashapixie]

No problem your guidance got me there in the end, am I right in thinking if I want a report with a criteria of "Staff" and one for "Operative" both in my type field that I will need two separate queries to run the report from?

 

[Joe4]

am I right in thinking if I want a report with a criteria of "Staff" and one for "Operative" both in my type field that I will need two separate queries to run the report from?

It depends...

Do you want two separate reports? Or two separate sections on the same report?
You could also make your query a "Parameter Query", which means it asks for the criteria at run-time. So, whenever you open the Report it will ask you for the criteria. Then you could use the same report for both instances.

 

[sashapixie]

Thanks, It was two separate reports, basically I have a button which opens the report in print preview I have one for Operatives and one for Staff, it sounds like I need to have the separate queries, which is cool as I have one input table for entering the info and the queries will do the rest in the background