Can I group my queries?
I have an MS-Acces 2010 database with about 15 tables. I'm creating loads of queries to answer specific questions. However, the list is growing quite large and it's getting a bit unwieldy. Is there any way I can group my queries into some sort of folder?
At the moment, the only way I can do it is to prefix the query name with a specific set of letters - but I'd like a better way if possible.
Thanks for any advice.
You could use the switchboard manager to setup a series of menus by query group that would be easy to use.
Another option would be use parameter queries if a series of queries have the same output fields you could then parametrize the fields you are selecting on so they ask you for the selection values at runtime. Just enter a * into any that don't apply to the current requirements. :cheers:
Parameters won't do it. The queries are all quite different.
I like the switchboard idea though. I'll have a play.....
You can customize the Navigation Pane to create your own Custom Categories and Custom groups - google Customizing Navigation pane. Or just right-click the Navigation Pane, select Navigation Options and have a play about!
Originally Posted by alan sh