Đã hoàn thành

MS Access / VBA update table records to fields in another table using linked field

In MS Access we have 2 tables:

Table1

Field1

Field2

Table2

Field1

Address1

Address2

Address3

Address4

Address5

We need VBA coded to update Table2 fields (Address1...Address5) with [url removed, login to view] where [url removed, login to view] = Table2.Field1. Note first record in [url removed, login to view] will be populated to Address1, second to Address2, third to Address3, forth to Address4 and fifth to Address5.

Where Address1 is blank or Address2 = Address1, move the addresses up, ie. Address2 becomes Address1, Address3 becomes Address2, Address4 becomes Address3, Address5 becomes Address4.

I will give the development database to persons who demonstrate in there initial response and possible further correspondence that they will be able to complete the task quickly and to requirements.

I will make a quick decision as I need project completed as soon as possible.

Thanks & good luck

Kĩ năng: Màn hình Windows

Xem nhiều hơn: access update table table using vba, access vba update table record, vba update field table field table access, access vba update table table, access vba update table field, access vba update field table, access vba update table record field, vba with, ms access database development, fifth third, access update field table vba, vba, ms access, ms access vba, ACCESS VBA, windows vba, blank fields, access linked table, quick note windows, table linked access

Về Bên Thuê:
( 91 nhận xét ) BONDI JUNCTION, Australia

ID dự án: #2774738

Được trao cho:

mobiletech1604

See private message.

$34 USD trong 2 ngày
(42 Đánh Giá)
5.6

4 freelancer đang chào giá trung bình $30 cho công việc này

gkalish

See private message.

$34 USD trong 2 ngày
(17 Nhận xét)
4.0
ashiva1976

See private message.

$30 USD trong 2 ngày
(2 Nhận xét)
0.0
pensoft87

See private message.

$20.4 USD trong 2 ngày
(0 Nhận xét)
0.0