combining columns

[Doris]

I have a column that contains 3 character alpha that I
want to merge with a column that has a 1 character alpha
(first column is the first letter of the last name
the second column the the next three letter of the last
name)
so, instead of having:

1st letter Last Name
A AAH

I want to end up with
AAAH

 

[DevalilaJohn]

You need to do that in a query. Assuming that you only want it for output,
in design mode enter something like this:

FullName: [col 1] & [col 2]

That will give you the complete last name. If you want to store the data
that way, add a column to you table and then use an update query similar to
the above to populate the data

 

[Guest]

thanks!!!!!

-----Original Message-----
You need to do that in a query. Assuming that you only want it for output,
in design mode enter something like this:

FullName: [col 1] & [col 2]

That will give you the complete last name. If you want to store the data
that way, add a column to you table and then use an update query similar to
the above to populate the data

I have a column that contains 3 character alpha that I
want to merge with a column that has a 1 character alpha
(first column is the first letter of the last name
the second column the the next three letter of the last
name)
so, instead of having:

1st letter Last Name
A AAH

I want to end up with
AAAH

.