Subj: Compare two tables Section: Database Issues To: John Nelson, 70641,3562 Saturday, October 24, 1998 3:08:51 PM From: Calvin G. Smith, 102226,2127 #722510 Hi John! >>> I need to compare data in two tables to look for changed records...It seems like there has got to be a better way. <<< If using MS Access (32-bit) tables, then Replication may be a better solution (See on-line help). Calvin Smith - Sr. Visual Basic/MS Access Consultant ******************************************************** http://www.CalvinSmithSoftware.com ******************************************************** Subj: Compare two tables Section: Database Issues To: John Nelson, 70641,3562 Saturday, November 07, 1998 6:06:47 PM From: Calvin G. Smith, 102226,2127 #723080 >>> Problem is I need to know which records changed so I can work my way backward to other tables and mark that they are effected. <<< Well, perhaps using the LastModified property can be of help (See on-line help). Calvin Smith - Sr. Visual Basic/MS Access Consultant ******************************************************** http://www.CalvinSmithSoftware.com ********************************************************