How do I run a report with updated query records?

  • Thread starter How do I run a report with updated query
  • Start date
H

How do I run a report with updated query

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

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 [email protected]> wrote in message
news:[email protected]...
 
F

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?
Click to expand...

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.
 
T

TedMi

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.
 
Top