display first letter of first name and last name fields

  • Thread starter Thread starter fcarter
  • Start date Start date
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
 
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
Click to expand...


.
Click to expand...
 
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
Click to expand...


.
Click to expand...
Click to expand...
 
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
Click to expand...
put
in
new column called initials. What do I need to do?

thanks,
fcarter


.
Click to expand...
Click to expand...


.
Click to expand...
 
Back
Top