can I copy a query, rename and revise the table relationship

G

Guest

I am new to access, can I copy a query, rename and revise the table
relationship to create new report using the structure of an old one
 
G

Guest

Yes

But ensure you redefine the source of the new report as the new query. You
can do this by opening the report in design view and opening the properties
box (right cick outside the detail area). Go to the Data column and select
the new query you have just made from the drop down list.

Good luck
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Tables and Relationships Question 1
Continued frustration with relationships and queries 1
table relationships and subdatasheets 9
Access Command button to look up and copy data from a query to a table 0
Relationships 7
Relationships and Keys 18
same field in more than one table 2
relationships 1

Top