I
ibeetb
If I run a query to create a recordset....and then copy it to Excel....and
then later on that day, I run the SAME query..but this 2nd recordset, based
on the same query as the first, has been updated with new items. What is the
easiest way to just compare this new recordset with the old one (or either
compare the two resulted recordsets once they have been copied to excel).
What I want to do is extract the updated items from recordset 2 and add them
to the results of recordset 1...would like to do in code.
Currentl;y, I copy both to excel and use array formulas to compare the
2...it takes far too loong.....
then later on that day, I run the SAME query..but this 2nd recordset, based
on the same query as the first, has been updated with new items. What is the
easiest way to just compare this new recordset with the old one (or either
compare the two resulted recordsets once they have been copied to excel).
What I want to do is extract the updated items from recordset 2 and add them
to the results of recordset 1...would like to do in code.
Currentl;y, I copy both to excel and use array formulas to compare the
2...it takes far too loong.....