From: dean.earley@icode.co.uk   
      
   JP wrote:   
   > Hello:   
   >   
   > I am doing an App in Visual Basic 6.0 and using an Access database.  I want   
   > to run an SQL statement in Visual Basic to get needed data.  then I need to   
   > run a second SQL based on the first one to isolate the totals I need for my   
   > report.  Can I run an SQL in Visual Basic and then "join" it with another   
   > SQL statement or Recordset to get my results?   
      
   You can use the results of one SQL statement in another, yes.   
   As for joining them into a single statement, it depends entirely on the   
   two statements :)   
      
   --   
   Dean Earley (dean.earley@icode.co.uk)   
   i-Catcher Development Team   
      
   iCode Systems   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)