Order By in Property List - but put in DESCENDING order

[MacNut2004]

Hello,

I see that you can put the orderby in VBA do determine sort order like this:
Me.OrderBy = "MyOrderByField"
Me.OrderByOn = True

But how do you make it sort in DESCENDING order??

Thank you!
MN

 

[chriske911]

Hello,

I see that you can put the orderby in VBA do determine sort order like this:
Me.OrderBy = "MyOrderByField"
Me.OrderByOn = True

But how do you make it sort in DESCENDING order??

Thank you!
MN

Me.OrderBy = "MyOrderByField DESC"

grtz

 

[Al Camp]

Mac,
Directly from "OrderBY Property" Access Help...
If you want to sort records in descending order, type DESC at the end of the
string expression. For example, to sort customer records in descending order
by contact name, set the OrderBy property to "ContactName DESC".

 

[MacNut2004]

THank you very much!

Me.OrderBy = "MyOrderByField DESC"

grtz

 

[jelutz]

Me.OrderBy = "MyOrderByField DESC"

grtz

This use of "DESC" isn't working for me. At least it doesn't work when I
enter it through the GUI. I've confirmed that it works with out the "DESC".