Find Unmatched Records Query 15.03.08
RFP: Find Unmatched Records Query
I need to query/compare four (4) tables that are identical in structure for unmatched records. They are Table#1, Table#1b and Table#2.
Table#1 and Table#1b are the reference or baseline tables.
Table#2 and Table#2 are the table that has changes in it.
After the query compare, I need for the changes in Table#2 and Table#2b to be written to a new table/s.
I am looking for four types of changes in Table#2 and Table#2b.
The changes I am looking for are as follows:
a. New employees added.
b. Old employees removed.
c. Current employee’s location changed.
d. Current employee’s phone number changed.
The reference tables, Table#1 and Table#1b exists in an MS SQL Server (Version 
database. I connect to this MS SQL database via an ODBC connection using MS Access 2003. I am then able to look at Table#1 and Table#1b as linked files.
My plan is to import a copy of Table#1 and Table#1b into MS Access 2003 before the weekly data update.
After the data update I shall again import a copy of Table#1 and Table#1b into MS Access 2003 and rename it as Table#2 and Table#2b.
The intention is then to run the query/comparison for unmatched records from within MS Access 2003 on Table#1/Table#1b and Table#2/Table#2b.
Or
To export Table#1/Table#1b and Table#2/Table#2b to MS Excel 2003 and run the Query/Comparison from within MS Excel 2003.
The preferred solution would be to run it from within MS Access 2003. A macro to automate this process is preferred. Please propose solutions.
Tables:
Table#1
EmpID 139339
EmpFirstName DENIS
EmpMiddleName C
EmpLastName LABINE
EmpLocationID 001001001001001000
EmpPhone 703-555-1000
EmpExtension
EmpEmail
EmpTitle
EmpDateTimeModified
EmpMemo
EmpCompanyID 74911
EmpWebPassword ascom
EmpCreateAlertsForAll FALSE
EmpWebAllowSearch FALSE
EmpWebAllowAlerts FALSE
EmpWebAllowPickUps FALSE
EmpCreatedDate
EmpEditedDate
EmpForwardLabel FALSE
EmpForwardCompany
EmpForwardAddress1
EmpForwardAddress2
EmpForwardAddress3
Table#1b
LocID 001000000000000000
LocTypeID 1
LocName 6410A>7H-630
LocDateTimeModified 3/7/08 7:19 PM
Thank you:
Kyei Amponsah
Kyei.amponsah(at)amponsahassociates.com
Tel: (202) 446-7344
SMS: (202) 446-7399
PS. Please see attached files for table structure.
