asp access

[hakanaktan]

here is my selection SELECTOR="SELECT * FROM MYTABLE WHERE MYDEF LIKE '%"& search &"%' ORDER BY MYDATE" I want to list the records by date but not old to new..wanna list recods ffrom new date to old ..would someone help?i do not have much time now.:(( --jcalone--

[Hesham Amin]

Hi All you need is to add the keyword desc

SELECTOR="SELECT * FROM MYTABLE WHERE MYDEF LIKE '%"& search &"%' ORDER BY MYDATE desc

[lanying_wzw]

the default is ascend, you want to descend, just append the string "DESC" thus your new SQL is: SELECTOR="SELECT * FROM MYTABLE WHERE MYDEF LIKE '%"& search &"%' ORDER BY MYDATE DESC" Thinking-Asking-Thinking