Multiple reports from one query

[Pjdelchi]

I have several reports that run from one query. Each report has one field
whose criteria is different and permanent. Instead of having to change the
query criteria every day for each report, can I filter through a report so
that I can just open the report and it filter for each report individually?

 

[Klatuu]

Yes.
Take all filtering out of your query.
Use your form to allow the user to make filtering options.
Use the Where Argument of the OpenReport method to to the filtering. The
Where argument is just like a Jet SQL WHERE Clause without the word where.

 

[Pjdelchi]

I do not have a form. Only tables, a query, and the report.

 

[Klatuu]

You need a form.