Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Access 2010 Query Display Sort Order

Posted on 2013-06-25
5
Medium Priority
?
588 Views
Last Modified: 2013-06-25
Hi Experts,

In the left hand window of Access 2010 ,some of my Access databases sort queries by type first and then alpha sort second (i.e. All update queries together)...other databases sort the queries alphabetically regardless of query type.  How do I toggle between these two views?
0
Comment
Question by:grmcra
  • 3
  • 2
5 Comments
 
LVL 4

Expert Comment

by:LCCSAM
ID: 39276062
If I understand your question correctly this can be done using the tiny (downward pointing) arrow next to "All Access Objects" at the top of the pane. I have included an image for clarification. Hope this helps you out!
Image of solution
0
 

Author Comment

by:grmcra
ID: 39276224
...I would like to change view '1' in the attached (clumped by update queries, crosstab queries, delete queries, etc.) to be the same type of view as in '2' where regardless of query type, alpha order overrides the query type....I played with the options in your image, but I still can't seem to get it to work....
1.JPG
2.JPG
0
 
LVL 4

Accepted Solution

by:
LCCSAM earned 1000 total points
ID: 39276281
I understand what you're asking now. Right click the "group" name (Queries) and choose "Sort by" then select "Name" and A-Z
I've embedded another image for you.
Hope this helps!
0
 

Author Closing Comment

by:grmcra
ID: 39276335
Thank you, you have no idea how much time I've spent trying to figure it out!
0
 
LVL 4

Expert Comment

by:LCCSAM
ID: 39276348
Glad to be of assistance!
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question