Ordering

[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.

 

[Arvin Meyer]

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.

 

[George Hester]

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?

 

[Van T. Dinh]

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?

 

[Arvin Meyer]

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?

 

[George Hester]

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.

 

[George Hester]

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.

 

[George Hester]

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.