Ordering

  • Thread starter Thread starter George Hester
  • Start date Start date
G

George Hester

Can I make the Jet Engine order a little differently? For example this is the way it is ordering these:

fuelsaverpro
fuels-savers

I would prefer it order like this:

fuels-savers
fuelsaverpro

It is not ordering the way I expect when an expression contains a -. I kinda would like it to order based on the ASC value for the character. Thanks.
 
I noticed the different behavior also. In Access 97 it does order the way
you'd expect. The only quick solution that I can offer is to create a sort
column and use that.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

Can I make the Jet Engine order a little differently? For example this is
the way it is ordering these:

fuelsaverpro
fuels-savers

I would prefer it order like this:

fuels-savers
fuelsaverpro

It is not ordering the way I expect when an expression contains a -. I
kinda would like it to order based on the ASC value for the character.
Thanks.
 
Arvin. In a book I have it says, "Although it is legal to use the ASC reserved word with an ORDER BY clause, it's not requires. Say I have this:

SELECT Products.*
FROM Products
ORDER BY UnitPrice DESC, ProductName;

How would I use the ASC reserved word here so that I can use for a sort order that corresponds to ASC?
 
Example of ASC:

.... ORDER BY UnitPrice ASC, ProductName ASC;

This won't help with your original question, though.

--
HTH
Van T. Dinh
MVP (Access)



Arvin. In a book I have it says, "Although it is legal to use the ASC
reserved word with an ORDER BY clause, it's not requires. Say I have this:

SELECT Products.*
FROM Products
ORDER BY UnitPrice DESC, ProductName;

How would I use the ASC reserved word here so that I can use for a sort
order that corresponds to ASC?
 
For an explanation, have a look at:

http://support.microsoft.com/default.aspx?id=236952

--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

Arvin. In a book I have it says, "Although it is legal to use the ASC
reserved word with an ORDER BY clause, it's not requires. Say I have this:

SELECT Products.*
FROM Products
ORDER BY UnitPrice DESC, ProductName;

How would I use the ASC reserved word here so that I can use for a sort
order that corresponds to ASC?
 
Well according to the book this will force the sort order to use ASC and not the default. So if it doesn't help and believe me I am not surprised then OBVIOUSLY Microsoft has neglected to consider ASCII as a decent way to sort in Access 2002. I'm going to try MSDE next. At least there I KNOW what the sort order is.
 
Yes I see that. And wouldn't you know it they give an example where the new result looks so much better. But hey what about this example:

www.micro-soft.com
www.microcsoft.com
www.micro1soft.com
www.micro.soft.com
www.microsoft.com

Now do you have any idea how Access 2002 will sort this ascending? I can tell you it is not what you expect. It actually comes out like this:

www.micro.soft.com
www.micro1soft.com
www.microcsoft.com
www.micro-soft.com
www.microsoft.com

It is anyone's guess where the - lies. It's greater then c and less then s but exactly where the cutoff is is arbitrary.
 
You know MSQuery does sort as expected. I wonder if we can integrate MSQuery into Access 2002 so we can get better sorting.

--
George Hester
__________________________________
Can I make the Jet Engine order a little differently? For example this is the way it is ordering these:

fuelsaverpro
fuels-savers

I would prefer it order like this:

fuels-savers
fuelsaverpro

It is not ordering the way I expect when an expression contains a -. I kinda would like it to order based on the ASC value for the character. Thanks.
 
Back
Top