Recordset question

[a2427]

Is it possible to query against a recordset. Some vendor software I am using exposes a DAO recordset to me, but I want to then filter the already present recordset. In essence, the vendor makes a query and returns to me the result of the query which I can do what I wish. I would like to make another query as opposed to looping through each recordset in the returned set.

Any suggestions.

I hate working without source code.

[jp_schwartz]

Instead of a recordset, create a view. A view is like a temporary table made by your query. Then, make a query to your view.

[a2427]

I can't say as I have ever seen nor heard the term VIEW, but then again I am not a database guru. Could you explain a little more, pleeeeeease. Or you could direct me to the info. Either way would be good.

thanks