table, add text to cell/cell

R

rrupp

I have 3 columns.
the first column is first name, the second column is last name and the third
column is our email address extension, for example @mercycare.org.
I want to take the first letter of the first name and last name column and
add it to the contents of the third column and copy that for all cells.

For example:
Column A John
Column B Smith
Column C @mercycare.org
The final column should be [email protected]
Anyway to do that? Hope I explained it well. Thanks for any assistance.
 
T

tina

are you doing this in Excel or in Access? (Excel spreadsheets have cells;
Access tables have fields.)

if in Access, perhaps you don't need to do it at all. you have the raw data
you need in FieldA and FieldB, and the rest of the email address is common
to all records. you can create the full address "on the fly" whenever you
need it, in a query, form, or report using an expression, as

Left(FieldA, 1) + FieldB + "@mercycare.org"

if you have a valid business reason for storing the value as hard data (i
can think of one or two), then you can update FieldC in an entire table with
an Update query, using the expression above.

hth
 
R

Rick B

Okay, a "cell" is an excel term. I'm assuming that since you posted this in
an Access newsgroup, that you actually are using Access.

To do this, you would simply concatenate the three items. You don't tell us
where you want this to happen. Are you trying to produce the result in a
report? A form? A query?

If in a query, then simply add a new column to your query and give it a
name. That name can then be used in reports of forms based on that query.
You don't tell us in your post, what the field names are, so I'll just make
some up for the example. Your entry would look like the following:

EmailAddress: [FirstName] & [LastName] & [EMExtension]


To do this in a form or a report, just create an unbound text box and put
the following in it:

=[FirstName] & [LastName] & [EMExtension]
 
R

Rick B

Oops. You only want the first letter of the first name.

Replace [FirstName] with Left([FirstName],1)



--
Rick B



Rick B said:
Okay, a "cell" is an excel term. I'm assuming that since you posted this
in an Access newsgroup, that you actually are using Access.

To do this, you would simply concatenate the three items. You don't tell
us where you want this to happen. Are you trying to produce the result in
a report? A form? A query?

If in a query, then simply add a new column to your query and give it a
name. That name can then be used in reports of forms based on that query.
You don't tell us in your post, what the field names are, so I'll just
make some up for the example. Your entry would look like the following:

EmailAddress: [FirstName] & [LastName] & [EMExtension]


To do this in a form or a report, just create an unbound text box and put
the following in it:

=[FirstName] & [LastName] & [EMExtension]

--
Rick B



rrupp said:
I have 3 columns.
the first column is first name, the second column is last name and the
third
column is our email address extension, for example @mercycare.org.
I want to take the first letter of the first name and last name column
and
add it to the contents of the third column and copy that for all cells.

For example:
Column A John
Column B Smith
Column C @mercycare.org
The final column should be [email protected]
Anyway to do that? Hope I explained it well. Thanks for any assistance.
Click to expand...
Click to expand...
 
Top