How to merge data

[Guest]

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 ?

 

[Joseph Meehan]

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.

 

[Guest]

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 ?

 

[Guest]

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 ?

 

[Joseph Meehan]

Well that could be done, but it would be easiest if you leave them in
the original three field format.

If you want a new line for each of the three sets of data, then I would
suggest that you don't want to combine the data into a single field.

--
Joseph Meehan

Dia 's Muire duit

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 ?