I have two tables with identical structures but different content. One table contains data on employees that have retired, terminated, resigned etc. The other table contains data on employees that are still active or still employed.
We want to compare the two tables to make sure that none of the records in the SpanInactive_DATE table appear in the SpanActive_DATE table and vice versa.
In the event that identical records are found that exist in both tables the results should be output to a Report that shall be called, DuplicateSpanActiveInactive
The field UserID shall be the used as the primary key.
This requirement is for the creation of an MS Access 2003 Database Query that will compare two MS Access tables and output the difference in a report. The Query shall be called Compare SpanActiveInactive.
The results of the Query shall be output to a Report of the same name. The report shall be called, Duplicate SpanActiveInactive. Clicking on the Report should be able to trigger and run the Query and generate the report.
The tables have identical structures. (See below).
The tables SpanActive_DATESTAMP: and SpanInactive_DATESTAMP: shall have as their source, text files with similar structure but different content. These text files will be imported into the MS Access database to create the MS Access tables that will be compared.
I am looking for a solution that will date stamp the text files when they are being imported to create the MS Access tables. The date format should be
The table name notation should be as follows:
The date will appear after the underscore sign. For example:
As such the Query / Report should be able to compare the tables from week to week even as the date portion of the table name changes.
This MS Access 2003 Database Query and Report should be able to run within an existing MS Access Database. I have attached a copy of the database to the project.