cozmo_troll
asked on
Is it possible to arrange queries in a database into folders?
We have several queries that are all one topic. Instead of have a list a mile long with everything jumbled together, can you arrange them into folders?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
>> Not that I'm aware of.
Guess I need to make myself more aware of things. :)
Guess I need to make myself more aware of things. :)
just a fyi...Jim's solution doesn't work in A97...if you're using A97 John has the best idea (and it's a good idea in any case)
Thanks Jim... I subscribed to see, and didn't know that was possible ^^
ASKER
Jim,
Will this mess up any of the links to reports?
Will this mess up any of the links to reports?
Their use/non-use in Groups has no effect on their functionality anywhere in your app. All you're doing is arranging shortcuts.
ASKER
Ok, seems to work. Thanks!
Here's an idea, though: rename your queries by putting the topic name at the beginning. Access sorts your queries in alphabetical order, so by doing this it will rearrange your queries by topic. Does that make sense?