How to pull up data from an existing select query

[Dominick D.]

Hello, Access Reporting Experts,

I want to create a report that is based on an existing select query. I want
to show the results of this query in a report. How do I bound the output of a
select query to the detail section of a report, so that, when I run the
query, when I execute a report, the output of the query will show in the
detail section? Also, how would I set all this up as a macro? Thanks.

 

[Marshall Barton]

I want to create a report that is based on an existing select query. I want
to show the results of this query in a report. How do I bound the output of a
select query to the detail section of a report, so that, when I run the
query, when I execute a report, the output of the query will show in the
detail section? Also, how would I set all this up as a macro? Thanks.

Reports open their record source query. You can't open a
query and the expect a report to use it.

In the report's design, set the report's Record Source
property to the name of your query. THen you can use a
macro with the OpenReport action to display the query's
records in the report.

 

[Dominick D.]

Thanks, but I've already discovered how to extract the query results and
display them in a report.