"AM COMS" <[EMAIL PROTECTED]> wrote on 01/23/2006 10:01:17 AM:
> I need to update a table without disturing the recordset however there are > or could be some overlaps with data is there a way I can compare id fro > the same 2 tables, one new one old? > > andrew > Your question is quite vague. What kind of comparison do you want to do. What kind of results do you want to have? What do you want to do with the comparisons once you get them? Basically you said "I have two boxes of things. Some of the things in one box may be the same as in another. How can I compare what's in my boxes?" Without knowing a bit more about your situation, nobody could do anything but guess towards giving you a reasonable solution for your real problem. Shawn Green Database Administrator Unimin Corporation - Spruce Pine