[AccessD] Comparing Values of Fields

When I needed to do this is did it in DAO (it was a while ago). I don't have
time to hunt the code out, but basically if you open a recordset for each
table you can then loop through the first recordset, finding the matching
row in the 2nd recordset, and then (if the fields are in the same order)
simply loop through the fields collection of both recordsets looking for
non-matching fields. Where you get a mismatch you can output the values of
both fields to a temp table. Then move on to the next row in rs1 and so
forth.

HTH

Roz

-----Original Message-----
From: Nicholson, Karen [mailto:cyx5 at cdc.gov] 
Sent: 02 November 2004 14:55
To: accessd at databaseadvisors.com
Subject: [AccessD] Comparing Values of Fields


We are maintaining a parts database.  I have the master parts database for
manufacturers in a table named tblParts.  The manufacturer submits to us an
updated parts list in a table named tblMrfParts.

tblParts contains 25 fields.

tblMfrParts contains the same 25 fields.

I need to compare the values in the 25 fields, tying part number to part
number.  If the value in the tblMfrParts is different for that part number
for any field, show our database field value and the manufacturers field
value.  

Suggestions?  Come on, I answered a question today...
-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
-------------- next part --------------

The contents of this message and any attachments are the property of Donns Solicitors 
and are intended for the confidential use of the named recipient only.  They may be legally
 privileged and should not be communicated to, or relied upon, by any other party without 
our written consent.  If you are not the addressee, please notify us immediately so that we 
can make arrangements for its return.  You should not show this e-mail to any person or
 take copies as you may be committing a criminal or civil offence for which you may be
 liable.  The statement and opinions expressed in this e-mail message are those of the 
writer, and do not necessarily represent that of Donns Solicitors.  Although any files attached
 to this e-mail will have been checked with virus protection software prior to transmission, 
you should carry out your own virus check before opening any attachment.  
Donns Solicitors does not accept any liability for any damage or loss which may be caused 
by software viruses...