Copying Queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can I copy a query and change the form from which it is getting its
information?

Say I have a query to seach bolts. I like the format but want it to search
cars on a different form and give a seperate report. Can I copy the query,
rename it and point it to a different form and thus table?

Thanks

David
 
Sure. Copy the query, giving the copy some meaningful name. Open the
form/report and change the recordsource to this new query.

You may find it easier to manage, if you set the recordsource to the SQL
statement, rather than a saved query. Just open your query and go to View,
SQL; copy the SQL statement, open the form/report and paste the SQL
statement into the recordsource. Then you don't need to keep the query.
 
You must log in or register to reply here.

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

Copying Database Structure 2
how to copy a database object in Access 2007 1
Form Not Showing Records buy Record Source Query Does 1
Access Access Report Works on One Machine but not Another 3
Where did i go wrong 1
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Print a report from another database 7
Forms used to run query 6

Back
Top