From: nomail@nospam.com   
      
   What about making this a 2 query process.   
      
   Query #1   
   Using a job key or keys,   
   simply do a one table query from jobitems,   
   and rename answer table to temp table.   
      
   Then query #2   
   Do your 2 table query that you do now...   
   but do not link 3 times into jobItems that has 1M plus records,   
   but link to your temp table that was created in Query #1.   
      
   Perhaps this could avoid errors that surface when you have multiple job   
   keys.   
      
   Good luck   
   Robert Wiltshire   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)