XPost: comp.lang.basic.visual.database   
   From: NOSPAMpanamahat@blueyonder.co.uk   
      
   "Henk Salomons"  wrote in news:d0nlva$jgn$1   
   @reader11.wxs.nl:   
      
   >     Question,   
   >   
   > Is it possible to use a AND in a find string, somthing like this:   
   >   Db.recordset.find("Collum1=London AND Collum2=Amsterdam")   
   >   
   > In this syntax is doesn't work, is there a way to do this??   
   >   
   > Greetings Henk   
   >   
   >   
   >   
      
   Well Henk you can set a SQL string with an 'AND' operator in it:   
      
   Dim strSQL as String   
   strSQL = "SELECT * FROM MyTable WHERE Collum1 = 'London' AND Collum2 =   
   'Amsterdam'"   
      
   Once you've set the strSQL variable, the exact method of passing the   
   string and obtaining the data will vary according to the data object you   
   are using.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)