combining 1st initial and another field?

[3Mark3]

Hello all,
I have a query and I'm trying to create a field that will be used as part of a form for creating e-mails. The field I'm trying to create will contain the first initial (or character) from the first name in my query, and combine it with the last name. An example:

John Doe = jdoe


I can't seem to figure out how to do this. Can anyone help direct me in the right direction? Your help is much appreciated, thank you!

 

[PHV]

LCase(Left([first name],1) & [last name])

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[3Mark3]

Excellent..I knew it had something to do witht he LCase...I was just typing the code wrong. Thank you very much!

Mark