How to pull up data from an existing select query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dominick D. - 24 Apr 2008 15:47 GMT

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.

Reply to this Message

Marshall Barton - 24 Apr 2008 17:01 GMT

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

Signature

Marsh
MVP [MS Access]

Reply to this Message

Dominick D. - 24 Apr 2008 20:46 GMT

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

> >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
[quoted text clipped - 9 lines]
> macro with the OpenReport action to display the query's
> records in the report.

Reply to this Message