i am having two recordsets, first one RS1 is associated with a table using "Select * from TableName" and is Opened.
2nd one RS2, is not yet opened.
i want to copy few records from RS1 which a criteria, say FieldName1 > Value1, to RS2.
RS2 is not associated with any table.
how can i do this, Please?