Sedang Disiapkan

227163 MS Table comparison Database

Background:

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

Primary Key:

The field UserID shall be the used as the primary key.

Task #1:

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.

Task #2:

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).

SpanActive_DATESTAMP:

1 EmpNumber

2 FirstName

3 MiddleName

4 LastName

5 FullName

6 EmpType

7 Status

8 StatusCode

9 CostCenter

10 Title

11 Phone

12 MailStop

13 Building

14 Floor

15 Office

16 EmpCode

17 UserID

18 TimeStamp

SpanInactive_DATESTAMP:

1 EmpNumber

2 FirstName

3 MiddleName

4 LastName

5 FullName

6 EmpType

7 Status

8 StatusCode

9 CostCenter

10 Title

11 Phone

12 MailStop

13 Building

14 Floor

15 Office

16 EmpCode

17 UserID

18 TimeStamp

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.

Task #3:

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

MMDDYYYY.

The table name notation should be as follows:

SpanActive_DATESTAMP

SpanInactive_DATESTAMP

The date will appear after the underscore sign. For example:

SpanActive_05302008

SpanInactive_05302008

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.

Note:

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.

Kemahiran: Semua Boleh, Microsoft Access, Visual Basic

Lihat lebih lanjut: we want employees, used structures, table data structure, key data structure, i am looking for employees, different data structures, data structure solution, data structures example, compare ms project, basic data structures in c, ms office project, table of content, table creation, query table, query creation, notation, database building 2, duplicate table, compare exist, access query table, office access create, report table, access database text, access table query, create project status report

Tentang Majikan:
( 6 ulasan ) Washington,

ID Projek: #1973401