How do I combine the data from 3 cells into 1?

[Guest]

Can you explain how to do that in steps? I'm a very beginner Access user,
thanks.

You are using terms as if you are talking about Excel. This is Access
newsgroup.

In Access just concatenate them together like --
[Column 1] & " " & [Column 2] & " " & [Column 3]

I Excel you would do this --
=Concatenate(A1, B1, C1)

Hi. I have a table that has the unit number, direciton and street name of
addresses all in seperate columns. I need to create a column that contains
all of these together. I have over a thousand records, so hand typing them
all out would take forever.

Example

Column 1 Column 2 Column 3 Merged Together
123 N Main ---> 123 N Main

 

[Guest]

Hi. I have a table that has the unit number, direciton and street name of
addresses all in seperate columns. I need to create a column that contains
all of these together. I have over a thousand records, so hand typing them
all out would take forever.

Example

Column 1 Column 2 Column 3 Merged Together
123 N Main ---> 123 N Main

 

[Joseph Meehan]

Can you explain how to do that in steps? I'm a very beginner Access
user, thanks.

Just type "COMBINEDNAME: [Column 1] & " " & [Column 2] & " " & [Column
3]" in an empty top row of a column (Access Field) of a query.

As you can see, we are all directing you to do this in a query and are
not suggesting saving the data in a table. We are not just remiss, but it
is better not to save data you can compute for a number of reasons.

Note: On your question about matching to another database. You can link
to a table or query in another Access database, or import if you like.
Start in the -File- -Get External Data- top line menu. However I am going
to suspect that you are going to run into some problems. How many address
are going to have N vs No vs North or even N. no direction indicator at
all. Same problem with street or St etc. Automatic matching is always a
problem unless all the data originated from the same source without human
action.

Good Luck

You are using terms as if you are talking about Excel. This is
Access newsgroup.

In Access just concatenate them together like --
[Column 1] & " " & [Column 2] & " " & [Column 3]

I Excel you would do this --
=Concatenate(A1, B1, C1)

Hi. I have a table that has the unit number, direciton and street
name of addresses all in seperate columns. I need to create a
column that contains all of these together. I have over a thousand
records, so hand typing them all out would take forever.

Example

Column 1 Column 2 Column 3 Merged
Together 123 N Main
---> 123 N Main

 

[Guest]

You will have a problem do what you want as addresses are entered in many
ways like --
123 N Main
123 North Main
123 N Main Street
123 N Main St
123 N Main St

Build a query using the table and the concatenating query. Join on the
appropriate fields for your address. Click on the connecting link between
tables and it opens another window. Select the option to give you all of the
date from one and only the records that match from the other. Close the link
window.

Ok, that worked.

Now, I have this query that has the full address together. Now, in another
database I have a table that has a list of full addresses. I need somehow to
match up the query and the table together. The table has a complete listing
of all the cities addresses, I just need to identify the ones I got in my
previous query.

example

Query Table
Address 1 Address 1
Address 2
Address 3 Address 3

If you create a new query from design view and add the table in question you
can merge fields. In the field box instead of selecting a field you can type
an expression.
For Example if you type:

FullAddress:[Unit Number] & " " & [Direction] & " " & [Street Name]

Into the field box and run the query the fields named will be merged into
one cell and the cells header will be FullAddress.

I hope this helps

Hi. I have a table that has the unit number, direciton and street name of
addresses all in seperate columns. I need to create a column that contains
all of these together. I have over a thousand records, so hand typing them
all out would take forever.

Example

Column 1 Column 2 Column 3 Merged Together
123 N Main ---> 123 N Main