"SELECT * FROM news ORDER BY date DESC" -----Original Message----- From: thelist-bounces at lists.evolt.org [mailto:thelist-bounces at lists.evolt.org]On Behalf Of Casey Crookston Sent: 19 June 2003 15:59 To: thelist at lists.evolt.org Subject: [thelist] ASP: 'Order By' question Using Access 2000 in an ASP app. Very simple Select statement: "SELECT * FROM news ORDER BY date" Naturally, it orders from the smallest date (oldest) to the largest (most recent). How do you get it to order it from largest to smallest? TIA, Casey -- * * Please support the community that supports you. * * http://evolt.org/help_support_evolt/ Evolt.org conference in London, July 25-27 2003. Register today at http://evolt.org.uk For unsubscribe and other options, including the Tip Harvester and archives of thelist go to: http://lists.evolt.org Workers of the Web, evolt !