R
RA
I have access to a Cisco ICM database. Whenever I make changes to the ICM
system, it updates the tables. To monitor the changes and to keep track of
the old information, I pull a report and save it in an Access database as a
new table, each report carries a table name by the date of the report. I
need to know how to pull a report that looks at two of these tables and
display all of the records where the information has changed. The standard
"Unmatched" query only pulls the records where the data is missing form the
newest report.
Often the changes may be small, ID 1234 was assigned to route 5678 now
assigned to 2341. SInce the valus isn't null, the new value isn't
identified. Any ideas?
system, it updates the tables. To monitor the changes and to keep track of
the old information, I pull a report and save it in an Access database as a
new table, each report carries a table name by the date of the report. I
need to know how to pull a report that looks at two of these tables and
display all of the records where the information has changed. The standard
"Unmatched" query only pulls the records where the data is missing form the
newest report.
Often the changes may be small, ID 1234 was assigned to route 5678 now
assigned to 2341. SInce the valus isn't null, the new value isn't
identified. Any ideas?