display first letter of first name and last name fields

F

fcarter

I am using Access 2000. In my table I have two columns,
one with first name and second with last name. I would
like to take the first letter from each column and put in
new column called initials. What do I need to do?

thanks,
fcarter
 
F

fcarter

Thanks for the information. Where do I enter this
information? Query? Module? Macro?

thanks,
Fcarter
-----Original Message-----
Left([FirstName], 1) & Left([LastName], 1)

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)


fcarter said:
I am using Access 2000. In my table I have two columns,
one with first name and second with last name. I would
like to take the first letter from each column and put in
new column called initials. What do I need to do?

thanks,
fcarter


.
 
D

Douglas J. Steele

Depends what you want to do with it.

If you want to be able to display it on a form or report, you can add it as
a computed field in a query, or you can set it as the Control Source for a
text box on the form or report (you'll need to put an equal sign in front of
it in that case), or you can set a text box's value in VBA code using
Me.txtInitials = Left(Me.FirstName, 1) & Left(Me.LastName, 1)

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)



fcarter said:
Thanks for the information. Where do I enter this
information? Query? Module? Macro?

thanks,
Fcarter
-----Original Message-----
Left([FirstName], 1) & Left([LastName], 1)

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)


fcarter said:
I am using Access 2000. In my table I have two columns,
one with first name and second with last name. I would
like to take the first letter from each column and put in
new column called initials. What do I need to do?

thanks,
fcarter


.
 
F

fcarter

Thank you for the information. I will try them out.
-----Original Message-----
Depends what you want to do with it.

If you want to be able to display it on a form or report, you can add it as
a computed field in a query, or you can set it as the Control Source for a
text box on the form or report (you'll need to put an equal sign in front of
it in that case), or you can set a text box's value in VBA code using
Me.txtInitials = Left(Me.FirstName, 1) & Left (Me.LastName, 1)

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)



fcarter said:
Thanks for the information. Where do I enter this
information? Query? Module? Macro?

thanks,
Fcarter
-----Original Message-----
Left([FirstName], 1) & Left([LastName], 1)

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)


I am using Access 2000. In my table I have two columns,
one with first name and second with last name. I would
like to take the first letter from each column and
put
in
new column called initials. What do I need to do?

thanks,
fcarter


.


.
 

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