ADP View in MSaccess not sorting properly

[toptech]

Hi All,

I create a simple view with 3 columns:

In MS SQL SERVER Management: VW_Property
Columns:
PropID,Property#, and Tenant

I sorted it by:
Property# - Ascending 1
Tenant - Ascending 2

When I run it in MS SQL SERVER Management it sorts properly.

When I run it in mty MSaccess 2007 app, it is sorted by propID.
Why does it ignore the designated sort order?
How do I fix it, so that it sorts corretly in my MSAcces App?

Thanks for assisstance in advance.

Toptech


Top Tech Systems

If you help 3 people and each one of those help 3 other people and so on, imagine all the people being helped.