Recordset Experts...SQL statement on an open recordset?
Is there a method of running a full SQL statement against an open recordset
to produce a subset of fields in a 2nd recordset? Filtering the open
recordset is too limited for what I have in mind, and I'd rather not requery
the database, since I have all of the info in the current recordset...if I
have a current recordset of 6 fields, what I'd like to do is something like:
SELECT field1, field2, field3 FROM current_recordset WHERE field1 =
some_value
(filtering will mimic the WHERE clause, but not the SELECT statement, thus
not producing a subset of fields)
Kit
