> Create your record set's first. The second recordset will use > a variable from the first in the WHERE clause. are you suggesting that it should run a query inside a loop? there is only one query and only one result set