Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Office > Misc

Reply
 
LinkBack Thread Tools Display Modes
  #1  
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
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't tab from field to field in form Lynieee Word 6 06-18-2012 02:37 PM
error: You are attempting to save a file format that is blocked by file block setting zatlas1 Office 8 04-28-2012 02:37 PM
Formula to subtract one month from due date field in reminder field ghumdinger Outlook 1 10-01-2011 12:09 AM
Word Macro That Checks a Check Box Form Field When File Print is Executed DKerne Word VBA 4 06-09-2011 11:54 AM
How to refer a field in another field DaveSmith Word 0 08-24-2010 06:44 PM


All times are GMT -7. The time now is 07:45 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft