Thread: File As Field
View Single Post
 
Old 11-07-2011, 05:18 PM
djclinton djclinton is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: May 2011
Posts: 7
djclinton is on a distinguished road
Default File As Field

In databases I often see a table which as a "File As" Field which displays the last name "," & then the first name combine into one field. I wish to have this in my Employee Table.

I.E.
FirstName LastName FileAs
Mark Jones Jones, Mark

I'm assuming that the "FileAs" field is a calculated (text) field, but I can't figure out the expression in Expression Builder.

I tried:
[FirstName]"," and [LastName]
[FirstName]"," + [LastName]

Any suggestions would be apprechiated!
Reply With Quote