Delete records in a recordset, based on another recordset

[geralf]

Hi all!

I need to 'subtract' a recordset from another recordset. Let me explain....

If I have a recordset A which has the following records: 1,3,5,6,7,8,9,10........

and a recordset B which has these records: 3,6 ,9

I want to get this recordset:

RecordsetResult: 1, 5,7,8,10.....

The recordsets are created with the OpenRecordset method. I dont want to affect the underlying data, I just want a resulting recordset as explained.

Is this possible, and if so, how can I do this.

Thanks in advance

 

[geralf]

Thanks for your reply and help Pat!

Worked very nice. I would never managed to come up with this neat solution!

Thanks again