How to specify display order of query objects with Access 2007

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
 
D

Dale Fye

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top