How do I run a report with updated query records?

[Guest]

There is an existing query that I doubl-click to run and there is an existing
report design. When I run the report I want it to point to the new query data
selected. Do I need to save the query as a table and then point to it somehow
in the report design view?

 

[John Spencer]

No, your report should point to the query as its source. When you open the
report to view or print, it will automatically run the query to get the data
it needs.


"How do I run a report with updated query" <How do I run a report with
updated (e-mail address removed)> wrote in message
news:[email protected]...

 

[fredg]

There is an existing query that I doubl-click to run and there is an existing
report design. When I run the report I want it to point to the new query data
selected. Do I need to save the query as a table and then point to it somehow
in the report design view?

Make the query the record source for the report.
You then run just the report, which in turn will get it's data from
the query. You never see the query.

 

[Guest]

If you set the report's record source to the query, the query will be rerun
each time you open the report, giving you the latest data that matches the
query.