From: joel@ecsnj.com   
      
   I'm scrolling by Order_# where I find and display on screen the < (lesser   
   then) value of Order_#. Here's the syntax:   
      
     "Select * From Orarchd Where `Order_#` < " & lngOrderNumber & " Order By   
   `Order_#` Desc"   
      
   lngOrderNumber is the current value of Order_#. Here's the problem: It   
   takes forever to find the next record (at least 10 seconds)   
      
   PS The Db is MySql   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)