Modifying an Access Query

[Phoen9]

I have created a report so when it is opened, the user passes two parameters to a query which then generates the report based on the query executing. (The query is set up to be the control source of the report) However, I want to hide/remove certain rows on the report after the query has returned values to the report. Is there a way to do this?

I can't alter the query to do what I want it to do. And I might need to write some VB that "onopen" re-queries the data and removes the rows I don't want but it has been awhile since I've coded.

Any help?

 

[Irish1957]

A method that has worked for me is roughly like this. Where human intervention is needed to edit material before reporting

1. Convert query to a make table query

2. Point the report at the new table

3. Open the new table and edit

4. Run report