Sort Groups?

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

Guest

Each month I create a new Group of shortcuts to sets of monthly audit
queries. I would like to sort the Groups in the Objects/Groups pane in
alphanumeric order. They will only sort based on the order they were created.
Not a big deal but what can I say - I'm an analyst...thanks
 
Each month I create a new Group of shortcuts to sets of monthly audit
queries. I would like to sort the Groups in the Objects/Groups pane in
alphanumeric order. They will only sort based on the order they were created.
Not a big deal but what can I say - I'm an analyst...thanks
Click to expand...

Um...!?

WHY are you creating multiple queries, one for each month?

If you're saving a query with #1/1/2007# (or the like) in the
criteria, and another query with #2/1/2007#, and so on.... consider
using a SINGLE query with a parameter.

It really sounds like you're trying to store data in query names, or
group names. This is neither necessary nor is it good design!

John W. Vinson [MVP]
 
Back
Top