You can use the Create Like feature to make a copy of a query.
- In Data, go to Queries.
- Check the check box next to the query to be copied.
- Select Create Like and give the new query a name.
- All the query criteria are copied over into the new query.
Copy a query
Comments
2 comments
Is it not possible to copy a query to a new database? I have a complex query using one database, and I would like to transfer a copy of that query to a different database.
It's only possible to copy (or create like) within the same database. Databases are independent of each other.
Please sign in to leave a comment.