populate 1 field from 2 fields 1

[mfd115]

Im a novice to Access 2003, but getting better. I have a table with three fields in it, ie.. EmployeeID, fname, lname.
What i want to do is to combine the lname field with the first letter of the fname field to create the EmployeeID field. From this; John Doe, to this; Doej.
I know (or think) this should be done at the after update event of the lname event, but cannot get it to work right. Any help please, thank you.

 

[PHV]

A starting point:
Me!EmployeeID = Trim(Me!lname) & Left(Me!fname, 1)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[ZmrAbdulla]

But it will be a problem if the employees' names start with same letters.. Like "John Doe" or "James Doe"

________________________________________________________
Zameer Abdulla
Help to find Missing people

 

[mfd115]

Thanks for the help, works great.

 

[Dontremb]

Why would you TRIM Lname?

Clearly it worked, but Why wouldn't it just be:

Me!EmployeeID = (Me!lname) & Left(Me!fname,1)

?

 

[TheAceMan1]

How are ya mfd115 . . .

The values in your EmployeeID field only need to be unique. [blue]The simplest, easiest unique generated values come from incrementing a numeric value[/blue] (like autonumber). Why not do this and be done with it?

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]