How to define query names to appear in alphanumeric order?

[ineuw]

In Access 2003 I was able to organize the query names in alphanumeric order, where a numeral set the order of display. for example:



01 empty table X
02 append to table X
03 display duplicates in table X
04 link table A to table X

In Access 2007 this is no longer possible because the order ignores the number prefix and sorts by the alpha characters, so this is what I get:

02 append to table X
03 display duplicates in table X
01 empty table X
04 link table A to table X

How can I order my queries as before?

[CJ_London]

a) you should not use numbers at the start of a name
b) instead of using 1,2,3, use A,B,C

[ineuw]

Thanks. It's a good idea, but my system worked in previous versions without any problems. Why was this changed? I know that variables can't start with numbers but query names?

[ineuw]

Sadly, using alpha doesn't work and nothing changed. Also created a new database and imported all the objects and there is still no change.

[CJ_London]

Price of progress. 2007 and later is less forgiving than earlier versions as it moves towards using sharepoint and azure - particularly with naming conventions. The fact you could do something in access does not mean it is a good idea. Many db's do not allow spaces in names for example and I'm sure at some point in the future, Access will not allow their use either.

However on reflection, your issue is not to do with names, but query types - see this link

https://support.office.com/en-us/art...ad=US&fromAR=1

find the section - display and sort objects, you can select sort by> name

[ineuw]

Thanks for the info and it's really enlightening . I really appreciate it and will rename the queries. Although for me, Microsoft is marching backwards to MSDOS. At first they were touting their ability to name objects with spaces and now they are forced to follow the rest of the world aka Unix/Linux and HTML. So we are back to underscores? and HungarianNotation. Shades of MSDOS :-)

[ineuw]

I deleted the queries and recreated them, letting Access name them Query1, Query2, etc., It turns out that Access orders the queries according to their type name!
1 = Append query
2 = Delete query
3 = Select query
4 = Update query

This is both strange and funny.

[CJ_London]

as I pointed out in post #5, you can base the sort on name rather than type

[ineuw]

Finally got it, it is a slow and a very hot Sunday where I am. Thanks for your patience.