Order By Question 1

[whodeycp]

Is there a way to order by two fields descending in vba? i know that it is possible for ascending. Here is an example of what I am trying to do:

If Me.OrderBy = "[Plan],[Year]" Then
Me.OrderBy = "[Plan],[Year] DESC"
Else
Me.OrderBy = "[Plan],[Year]"
End If
Form.OrderByOn = True

It works for ascending but not descending.

 

[HarleyQuinn]

How about:

Me.OrderBy = "[Plan] DESC,[Year] DESC"

Hope this helps

HarleyQuinn
---------------------------------
Carter, hand me my thinking grenades!

You can hang outside in the sun all day tossing a ball around, or you can sit at your computer and do something that matters. - Eric Cartman

Get the most out of Tek-Tips, read FAQ222-2244: How to get the best answers before posting.

http://lessthandot.com

 

[whodeycp]

That works great. Thanks Harley, I was stuck there.

 

[HarleyQuinn]

Glad I could help, thanks for the star

HarleyQuinn
---------------------------------
Carter, hand me my thinking grenades!

You can hang outside in the sun all day tossing a ball around, or you can sit at your computer and do something that matters. - Eric Cartman

Get the most out of Tek-Tips, read FAQ222-2244: How to get the best answers before posting.

http://lessthandot.com