How to merge data

C

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 ?
 
C

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

Joseph Meehan said:
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


CP said:
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 ?
 
C

CP

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

CP said:
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

Joseph Meehan said:
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


CP said:
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 ?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top