Cliptext??

  • Thread starter Thread starter Gavin
  • Start date Start date
G

Gavin

Hello all.

I am working on an automated username creator.
This is my situation:
I want to capture the 1st letter of [Firstname] and the
entire [Lastname] along with the [date of birth / DOB] and
place that value into the [UserID] field. I am able to get
the entire [Firstname]+[Lastname]+[DOB].

Also, for the [DOB] field, is there anyway to not have
the "_" and "/" symbols? As it stands, my test userID
looks like: JohnDoe_4/_1/2004 I would like for it to
look like: jdoe04012004

Please any help is apprecieated

Thanx.
 
Okay. I figured out the Firstname part, but I am still
having trouble coverting the [DOB] (displays as
_4/_1/2004) to display as 04012204. Please read below for
more details.

thanx.
 
Hello all.

I am working on an automated username creator.
This is my situation:
I want to capture the 1st letter of [Firstname] and the
entire [Lastname] along with the [date of birth / DOB] and
place that value into the [UserID] field. I am able to get
the entire [Firstname]+[Lastname]+[DOB].

Also, for the [DOB] field, is there anyway to not have
the "_" and "/" symbols? As it stands, my test userID
looks like: JohnDoe_4/_1/2004 I would like for it to
look like: jdoe04012004

Please any help is apprecieated

Thanx.
Click to expand...


[UserID] =Left(FirstName],1) & [LastName] & Format([DOB],"mmddyyyy")
 
Okay. I figured out the Firstname part, but I am still
having trouble coverting the [DOB] (displays as
_4/_1/2004) to display as 04012204. Please read below for
more details.
Click to expand...

Format([DOB], "mmddyyyy")

assuming that the person was born two hundred years hence said:
thanx.
-----Original Message-----
Hello all.

I am working on an automated username creator.
This is my situation:
I want to capture the 1st letter of [Firstname] and the
entire [Lastname] along with the [date of birth / DOB] and
place that value into the [UserID] field. I am able to get
the entire [Firstname]+[Lastname]+[DOB].

Also, for the [DOB] field, is there anyway to not have
the "_" and "/" symbols? As it stands, my test userID
looks like: JohnDoe_4/_1/2004 I would like for it to
look like: jdoe04012004
Click to expand...
Click to expand...

And if you have his twin sister Janet Doe as another employee???
 
Back
Top