L
Lisa
Thank you in advance …..Any help would be greatly appreciated. I have two
tables, Table one is an “Import Table†and Table 2 is an exact match “Update
Table†(the site number is the primary key). What I am trying to do is match
one to the other and tell me what the difference is in another Queries or
Table. I have over 2000 rows and 100 columns to match up. There will only be
information changed in one table “Update Tableâ€. See below….
Table 1 “Import Tableâ€
Site Col1 col2 col3
123 1/1/07 1/1/07 1/1/07
234 1/1/07 1/1/07 1/1/07
543 1/1/07 1/1/07 1/1/07
Table 1 "Update Table"
Site Col1 col2 col3
123 1/2/07 1/1/07 1/2/07
234 1/1/07 1/4/07 1/1/07
543 1/3/07 1/1/07 1/1/07
New Queries
Site Col1 col2 col3
123 1/2/07 1/2/07
234 1/4/07
543 1/3/07
tables, Table one is an “Import Table†and Table 2 is an exact match “Update
Table†(the site number is the primary key). What I am trying to do is match
one to the other and tell me what the difference is in another Queries or
Table. I have over 2000 rows and 100 columns to match up. There will only be
information changed in one table “Update Tableâ€. See below….
Table 1 “Import Tableâ€
Site Col1 col2 col3
123 1/1/07 1/1/07 1/1/07
234 1/1/07 1/1/07 1/1/07
543 1/1/07 1/1/07 1/1/07
Table 1 "Update Table"
Site Col1 col2 col3
123 1/2/07 1/1/07 1/2/07
234 1/1/07 1/4/07 1/1/07
543 1/3/07 1/1/07 1/1/07
New Queries
Site Col1 col2 col3
123 1/2/07 1/2/07
234 1/4/07
543 1/3/07