I have a requirement to create two recordsets from with VB6 - no problems here, but I then need to compare records within the two recordsets (there are two common fields in each recordset) and either create a new recordset or change one of the existing recordsets.

Is this possible - if so how do I do it.