[AccessD] Ascending/Descending Indexes - Retrying

Charlotte Foust cfoust at infostatsystems.com
Tue Feb 22 11:25:39 CST 2005


It depends on how you're using it.  You can change the SQL by adding the
DESC keyword to the Order By expression.  If you're using a recordset to
do a find, change it's orderby the same way.

Charlotte Foust


-----Original Message-----
From: Gustav Brock [mailto:Gustav at cactus.dk] 
Sent: Tuesday, February 22, 2005 9:13 AM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Ascending/Descending Indexes - Retrying


Hi Charlotte

Never thought of that. 
How do you do such a change?

/gustav

>>> cfoust at infostatsystems.com 22-02-2005 18:02:15 >>>
If you have already indexed the field, you don't need another index
defined.  Just change the direction of the sort in code.

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list