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

Windows Desktop

Rif. progetto: #2774738

Info sul progetto