Sedang Disiapkan

224366 MS Access Table Comparison DB

This is an urgent project. A bonus will be paid for quick delivery.

Background:

I have an MS Access 2003 database with two (2) (MS Access 2003) tables in it.

A new table is imported every week.

The structure of both tables is identical. (Please see below).

ThisWeek_date LastWeek_date

Table 2

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

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

I need queries that will compare both tables and look for changes in the tables form one week (or table) to another.

The changes being sought are in the shaded fields (Field 1 to Field 17)

The changes found must then be “written” directly to an MS Access 2003 database report in the same database.

The preference is to develop an individual query and report for each camparison.

Please see below for details of changes, queries and reports on page 2..

Please see below for query and reports names page 3.

Queries/Changes:

Employees_Added:

Values in FullName fields that exist in table ThisWeek_date but do not exist in table LastWeek_date.

Employees_Changed CostCenter:

Value in CostCenter field that has changed in table ThisWeek_date to table LastWeek_date when compared against the value in the UserID fields for both tables.

Employees_Changed EmpCode:

Value in EmpCode field that has changed in table ThisWeek_date to table LastWeek_date when compared against the values in the UserID fields for both tables.

Employees_Changed FullName:

Value in FullName field that has changed in table ThisWeek_date to table LastWeek_date when compared against the value in the UserID fields for both tables.

Employees_Changed Location:

Values in the Building, Floor and MailStop fields that have changed form table ThisWeek_date to table LastWeek_date when compared against the value in the UserID fields for both tables.

Employees_Changed Phone:

Value in the Phone field that has changed in table ThisWeek_date to table LastWeek_date when compared against the value in the UserID fields for both tables.

Employees_Changed EmpType:

Value in EmpType field that has changed in the table ThisWeek_date to Table LastWeek_date when compared against the value in the UserID fields for both tables.

Employees_Changed Status:

Value in Status field that has changed in the table ThisWeek_date to Table LastWeek_date when compared against the value in the UserID fields for both tables.

Employees_Changed StatusCode:

Value in StatusCode field that has changed in the table ThisWeek_date to table LastWeek_date when compared against the value in the UserID fields for both tables.

Employees_Changed Title:

Value in Title field that has changed in the table ThisWeek_date to Table LastWeek_date when compared against the value in the UserID fields for both tables.

Employees_Removed:

Values in UsedID, FirstName, MiddleName, LastName and FullName fields that do not exist in the table for ThisWeek_date but, exist in the table from LastWeek_date.

Query Names:

Employees Added

Employees Removed

Employees Changed CostCenter

Employees Changed EmpCode

Employees Changed FullName

Employees Changed Location

Employees Changed Phone

Employees Changed EmpType

Employees Changed Status

Employees Changed StatusCode

Employees Changed Title

Report Names:

Employees Added

Employees Removed

Employees Changed CostCenter

Employees Changed EmpCode

Employees Changed FullName

Employees Changed Location

Employees Changed Phone

Employees Changed EmpType

Employees Changed Status

Employees Changed StatusCode

Employees Changed Title

Kemahiran: Semua Boleh, Microsoft Access, Visual Basic

Lihat lebih lanjut: access table comparison, need microsoft office, query table, ms access, db query, compare exist, access query table, shaded, report table, table queries, access table query, access table query form, access database form reports, access floor, project office microsoft, access database employees, table exist, compare access database, compare access, access page found, changes access, need comparison, access project database, project report background, access form look report

Tentang Majikan:
( 6 ulasan ) Washington,

ID Projek: #1970602

Dianugerahkan kepada:

somalasl

Hi sir, Please see My PM. i have already done the work. Please let me know is it use full to you . i can do the necessory changes if you want. you can reach me at somala_pratap at yah C I . please give me you f Lagi

$10 USD dalam sehari
(0 Ulasan)
0.0