How to specify display order of query objects with Access 2007

  • Thread starter Thread starter b_nuttall
  • Start date Start date
B

b_nuttall

I have an Access database that uses a sequence of select, update, and append
queries that must be executed in order to perform certain synchronization
tasks. In Access 2007 the lists of queries are now arranged by query type and
then alphabetically by query name. How do I specify that I want the order of
the list of query names to be alphabetic only (regardless of query type).

Note, I don't want help with writing queries or specifiying the sort order
of records returned by executing a query. That's all I can get to come up in
the MS Office help.

Thanks
 
If you right click on the navigation pane (where it says All Access Objects)
you will see a shortcut window and options for Category, Sort By, and View By.

Click on Category and select Object Type
Click on Sort By and select Name

--
HTH
Dale

email address is invalid
Please reply to newsgroup only.
 
Back
Top