p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

access thread: Access 2000 macro help


Message #1 by "Steve Burr" <steveb1164@a...> on Wed, 6 Jun 2001 17:37:08
 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. 
Message #2 by "Pardee, Roy E" <roy.e.pardee@l...> on Wed, 06 Jun 2001 10:18:19 -0700
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. 




  Return to Index