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