In MS Access we have 2 tables:
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