Recordset from a Recordset

[BigJimSlade]

Hi, Big Jim here:

I was hoping that I could create a recordset from a recordset.

Say I have rst1 and rst2.....I want to select for rst2 only one or two fields in rst1, and I would have to use the "DISTINCT" predicate (ie SELECT DISTINCT [fields]) so that I would not have duplicate data.

Is this possible?

Thanks in advance!

Big Jim

 

[AlanS]

I'm not sure if you can use one recordset in the SQL statement that defines a second recordset. If so, great. If not, try duplicating the first recordset as a query, and then name the query in the SELECT statement.

 

[BigJimSlade]

Thanks Alan!

I think I am going to build a collection to hold the data that I need.

I appreciate your help.


Big Jim