[AccessD] Ascending/Descending Indexes - Retrying

Gustav Brock Gustav at cactus.dk
Tue Feb 22 11:33:11 CST 2005


Hi Chorlotte

Ahh, I know that - thought there was some secret to "reverse" an
index.

/gustav

>>> cfoust at infostatsystems.com 22-02-2005 18:25:39 >>>
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 
-- 
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