>I tried this by generating two recordset objects.
>
>Then I tried to create a third recordset object which took a SQL string that refrenced fields in the first two recordset objects. This resulted in an error.
>
>How do I go about this problem?

Simply not possible.

You can store the 1st 2 queries in temp tables and use them for your last query.

You can also have a query that have include multiple queries.