If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Order By in Property List - but put in DESCENDING order
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 |
#2
|
|||
|
|||
Order By in Property List - but put in DESCENDING order
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 |
#3
|
|||
|
|||
Order By in Property List - but put in DESCENDING order
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". -- hth Al Camp Candia Computer Consulting - Candia NH http://home.comcast.net/~cccsolutions "MacNut2004" wrote in message ... 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 |
#4
|
|||
|
|||
Order By in Property List - but put in DESCENDING order
THank you very much!
"chriske911" wrote: 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 |
#5
|
|||
|
|||
Order By in Property List - but put in DESCENDING order
"chriske911" wrote:
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 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". |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
List Box ListCount property seems to be incorrect... | Bob Howard | Using Forms | 7 | August 5th, 2005 05:40 AM |
Order By property | NikkiB | Using Forms | 3 | June 30th, 2005 09:54 PM |
Order By Property | Jake | Using Forms | 2 | April 11th, 2005 07:35 PM |
reading order property | Bwalker252 | Using Forms | 1 | November 25th, 2004 03:42 PM |
Inhereting the sort order | Dan St.John | Setting Up & Running Reports | 1 | July 9th, 2004 03:30 AM |