I have two fields in a FMP 7 db. One is LastName and the other is
FirstName. I would like to create a calculated field that will take the
Last Name and add to it the first letter of the First Name. John Doe would
become doej

Could someone get me started in this??

Thanks

Name = LastName & " " & Left(FirstName, 1) & "."
Remi-Noel


"Stephen Larivee" <NOlariveeslSPAM (AT) yahoo (DOT) PLEASEcom> a écrit dans le
message de news: lKOdnZl9UMkK1mbfRVn-2g (AT) comcast (DOT) com...

Stephen Larivee <NOlariveeslSPAM (AT) yahoo (DOT) PLEASEcom> wrote:


Maybe you need a comma instead of semicolon to separate arg for the Left
function, depending on your language / region.

It shoud be that easy - hope it helps.
Jens

Stephen Larivee wrote:

CombinedName = LastName & Left (FirstName ; 1 )

If you actually want it to be lower case all the way as you indicate in
your example, make it

CombinedName = Lower ( LastName & Left (FirstName ; 1 ) )

You'll find other examples in Help under Text functions.

Matt

Thank you, all of you, for the help. Problem resolved!!!!


"Remi-Noel Menegaux" <rnmenegaux (AT) free (DOT) fr> wrote