Alpha characters

[ED]

I am trying to take the first initial of the last name of an employee
and add as the first character of their employee number. Is there an
easy way to do this?

Thanks

[fredg]

Re: Alpha characters

On 23 Jun 2004 06:39:46 -0700, ED wrote:
[color=blue]
> I am trying to take the first initial of the last name of an employee
> and add as the first character of their employee number. Is there an
> easy way to do this?
>
> Thanks[/color]

Let's see if I understand what you wish to do.
Last name = "Smith"
Employee# = 12345

You wish to get "S12345", correct?

=Left([LastName],1) & [EmployeeNumber]
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.

[Ernie DAmato]

Re: Alpha characters


Thanks that worked. It has been a long time since I have worked in
access so I am just trying to get my bearings together.


*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!