I want to compare 2 tables in Access 2000 record by record. Using the 

primary key, I need to check one field to see if it is different in the 2 

tables. If it is, I want to write the whole record to a different table, 

then go to the next record. I want to do this in Access before I upload 

the database to the server. Can anyone help? Thanks. 

A query will likely be much easier--join your two tables on the key, and

select both fields.  Then (assuming the field is called MyField in both

tables, and the tables are called Table1 and Table2) put



<> [Table2].[MyField]



In the criteria row for the MyField coming from Table1.



HTH,



-Roy



-----Original Message-----

From: Steve Burr [mailto:steveb1164@a...]

Sent: Wednesday, June 06, 2001 9:51 AM

To: Access

Subject: [access] Access 2000 macro help





 I want to compare 2 tables in Access 2000 record by record. Using the 

primary key, I need to check one field to see if it is different in the 2 

tables. If it is, I want to write the whole record to a different table, 

then go to the next record. I want to do this in Access before I upload 

the database to the server. Can anyone help? Thanks.