Multiple reports from one query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pjdelchi - 19 Dec 2007 16:21 GMT

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?

Reply to this Message

Klatuu - 19 Dec 2007 18:16 GMT

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.

Signature

Dave Hargis, Microsoft Access MVP

> 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?

Reply to this Message

Pjdelchi - 19 Dec 2007 20:19 GMT

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

> Yes.
> Take all filtering out of your query.
[quoted text clipped - 6 lines]
> > 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?

Reply to this Message

Klatuu - 19 Dec 2007 20:23 GMT

You need a form.

Signature

Dave Hargis, Microsoft Access MVP

> I do not have a form. Only tables, a query, and the report.
>
[quoted text clipped - 8 lines]
> > > 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?

Reply to this Message