Link a report and query

[lbradbury]

Hello,

I have a report built that I would like to be populated based on a new query written. How do I link the two so that when the query runs the report data populates based on that.

 

[Joe4]

If you use the Query as Record Source for your Report, the Report will ALWAYS pull the data from that Query (note that Reports can use Query just as easily as Tables for the source of its data).
You don't need to do anything to "push the data" or "refresh it". When you open the Report, it will automcatically pull the most current data from your Query.
The only situation which wouldn't have refreshed data is if you open the Report, keep it open, and make changes to the Query while the Report is open. You would need to close and re-open the Report to capture those changes you made while the Report was open.

 

[lbradbury]

If you use the Query as Record Source for your Report, the Report will ALWAYS pull the data from that Query (note that Reports can use Query just as easily as Tables for the source of its data).
You don't need to do anything to "push the data" or "refresh it". When you open the Report, it will automcatically pull the most current data from your Query.
The only situation which wouldn't have refreshed data is if you open the Report, keep it open, and make changes to the Query while the Report is open. You would need to close and re-open the Report to capture those changes you made while the Report was open.

Thank you!!!

 

[Joe4]

You are welcome.