Is there any way to copy an existing query and save to another name? i have several Queries to make with basically the same info just need to filter each one differently and would like to create different queries for each one instead of having to change the filters each time and it would be nice to be able to copy and rename them instead of having to build several of the same thing form scratch.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Copy Query
- Thread starter bwlytkr
- Start date
1) select query in nav pane; ctrl+c, ctrl+v, rename in Save As prompt, edit in design view.
2) right click on nav pane object, choose from menu, edit new version in design
3) open in design view, click save button at top left of Access window or ctrl+s, edit in design
4) best: don't duplicate queries at all.
You should be running a single query from a form and provide the parameters from the form. I suspect you're running queries directly. If you need to modify (e.g. add a field to a query) you are fixing what, 6? 10? copies instead of one. Not to mention that it just creates unnecessary overhead.
2) right click on nav pane object, choose from menu, edit new version in design
3) open in design view, click save button at top left of Access window or ctrl+s, edit in design
4) best: don't duplicate queries at all.
You should be running a single query from a form and provide the parameters from the form. I suspect you're running queries directly. If you need to modify (e.g. add a field to a query) you are fixing what, 6? 10? copies instead of one. Not to mention that it just creates unnecessary overhead.
Upvote
0
Similar threads
- Solved
