Dear all,

I already have a table. In this table, I have three columns for id,
firstName, LastName. How can I get three more columns for the FirstInitial,
LastInitial, and Initial? FirstInitial is the first letter of firstName,
LastInitial for the first letter for LastName, and Initial needs put the
LastInitial and FirstInitial together.

The records in my table look like:
id FirstName LastName
00021 Mary Smith
01234 John Atikins

The table I expect will look like:
id FirstName LastName FirstInitial LastInitial Initial
00021 Mary Smith M S SM
01234 John Atikins J A AJ


Can anybody help, Thanks,


Blinda








I

You don't need to actually store all of these. You can use the Left()
function to find these values anytime you want. For instance, in a query you
can put:
FirstInitial: Left(FirstName, 1)
LastInitial: Left(LastName,1)
Initial: Left(LastName,1) & Left(FirstName, 1)
each in its own field column.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L




"Blinda" <(E-Mail Removed)> wrote in message
news:8545618C-F717-494C-A5B9-(E-Mail Removed)...
> Dear all,
>
> I already have a table. In this table, I have three columns for id,
> firstName, LastName. How can I get three more columns for the
FirstInitial,
> LastInitial, and Initial? FirstInitial is the first letter of firstName,
> LastInitial for the first letter for LastName, and Initial needs put the
> LastInitial and FirstInitial together.
>
> The records in my table look like:
> id FirstName LastName
> 00021 Mary Smith
> 01234 John Atikins
>
> The table I expect will look like:
> id FirstName LastName FirstInitial LastInitial Initial
> 00021 Mary Smith M S SM
> 01234 John Atikins J A AJ
>
>
> Can anybody help, Thanks,
>
>
> Blinda
>
>
>
>
>
>
>
>
> I

Thank you so much, it works perfectly for me.

"Roger Carlson" wrote:

> You don't need to actually store all of these. You can use the Left()
> function to find these values anytime you want. For instance, in a query you
> can put:
> FirstInitial: Left(FirstName, 1)
> LastInitial: Left(LastName,1)
> Initial: Left(LastName,1) & Left(FirstName, 1)
> each in its own field column.
>
> --
> --Roger Carlson
> MS Access MVP
> Access Database Samples: www.rogersaccesslibrary.com
> Want answers to your Access questions in your Email?
> Free subscription:
> http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L
>
>
>
>
> "Blinda" <(E-Mail Removed)> wrote in message
> news:8545618C-F717-494C-A5B9-(E-Mail Removed)...
> > Dear all,
> >
> > I already have a table. In this table, I have three columns for id,
> > firstName, LastName. How can I get three more columns for the
> FirstInitial,
> > LastInitial, and Initial? FirstInitial is the first letter of firstName,
> > LastInitial for the first letter for LastName, and Initial needs put the
> > LastInitial and FirstInitial together.
> >
> > The records in my table look like:
> > id FirstName LastName
> > 00021 Mary Smith
> > 01234 John Atikins
> >
> > The table I expect will look like:
> > id FirstName LastName FirstInitial LastInitial Initial
> > 00021 Mary Smith M S SM
> > 01234 John Atikins J A AJ
> >
> >
> > Can anybody help, Thanks,
> >
> >
> > Blinda
> >
> >
> >
> >
> >
> >
> >
> >
> > I
>
>
>

the first letter of ANYTHING in Access is _F_ because MDB gets an F for
security, reliability and performance reasons



On Nov 3, 11:53 am, Blinda <Bli...@discussions.microsoft.com> wrote:
> Dear all,
>
> I already have a table. In this table, I have three columns for id,
> firstName, LastName. How can I get three more columns for the FirstInitial,
> LastInitial, and Initial? FirstInitial is the first letter of firstName,
> LastInitial for the first letter for LastName, and Initial needs put the
> LastInitial and FirstInitial together.
>
> The records in my table look like:
> id FirstName LastName
> 00021 Mary Smith
> 01234 John Atikins
>
> The table I expect will look like:
> id FirstName LastName FirstInitial LastInitial Initial
> 00021 Mary Smith M S SM
> 01234 John Atikins J A AJ
>
> Can anybody help, Thanks,
>
> Blinda
>
> I