Is there away to reattach a query to an access report?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dez - 12 Dec 2005 16:14 GMT

I had to delete a query that I was using to produce a report in access? I
remade the query with the exact same fields. Is there a way to "reattach"
that query to the report?

Reply to this Message

Allen Browne - 12 Dec 2005 16:19 GMT

Open the report in design view.

Open the Properties box (View menu). Make sure its Title says Report, so you
are looking at the properties of the report and not those of a control.

On the Data tab of the properties box, set the Record Source property to the
name of your query.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I had to delete a query that I was using to produce a report in access? I
> remade the query with the exact same fields. Is there a way to "reattach"
> that query to the report?

Reply to this Message

Dez - 12 Dec 2005 16:30 GMT

Thanks Allen... That worked perfectly.

> Open the report in design view.
>
[quoted text clipped - 7 lines]
> > remade the query with the exact same fields. Is there a way to "reattach"
> > that query to the report?

Reply to this Message