How to merge data

[CP]

I have now completed a design on my database - however something I didnt
count on has been given to me, The address data (1200 records) are seperated
and I need to merge them somehow

Actual data is like this
Name
Add1
Add2
Add3
City
Province

New database is this
Name
Address
City
Province

How can I merge the 3 Add fields into the one address field ?

 

[CP]

Ok I can see the how this works - still having trouble though

I have the new empty Table
Clients - Name, Address, tel
and the old data Table
Clients - Name, Add1, Add2, Add3, Tel

Both are in access already but the idea was to delete the old table once
merged - where do I put [ADD1]&" "&[ADD2]&"&[ADD3] ? as on the new table I am
unsure

The exact method would depend on where the data is now, like in a text
file, a table etc.

Once you get it into Access then you would want to use a formula
something like:

[ADD1]&" "&[ADD2]&"&[ADD3] to populate the new field. You could clean it
up to eliminate un-needed spaces and you may want to make some accommodation
for some long address lines.

--
Joseph Meehan

Dia 's Muire duit

I have now completed a design on my database - however something I didnt
count on has been given to me, The address data (1200 records) are
seperated
and I need to merge them somehow

Actual data is like this
Name
Add1
Add2
Add3
City
Province

New database is this
Name
Address
City
Province

How can I merge the 3 Add fields into the one address field ?

 

[CP]

Oh and I would wish each field to exist on a new line in field if that makes
sense?

Ok I can see the how this works - still having trouble though

I have the new empty Table
Clients - Name, Address, tel
and the old data Table
Clients - Name, Add1, Add2, Add3, Tel

Both are in access already but the idea was to delete the old table once
merged - where do I put [ADD1]&" "&[ADD2]&"&[ADD3] ? as on the new table I am
unsure

The exact method would depend on where the data is now, like in a text
file, a table etc.

Once you get it into Access then you would want to use a formula
something like:

[ADD1]&" "&[ADD2]&"&[ADD3] to populate the new field. You could clean it
up to eliminate un-needed spaces and you may want to make some accommodation
for some long address lines.

--
Joseph Meehan

Dia 's Muire duit

I have now completed a design on my database - however something I didnt
count on has been given to me, The address data (1200 records) are
seperated
and I need to merge them somehow

Actual data is like this
Name
Add1
Add2
Add3
City
Province

New database is this
Name
Address
City
Province

How can I merge the 3 Add fields into the one address field ?