Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-07-2011, 05:18 PM
djclinton djclinton is offline File As Field Windows 7 32bit File As Field Office 2010 32bit
Novice
File As Field
 
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
File As Field Can't tab from field to field in form Lynieee Word 6 06-18-2012 02:37 PM
File As Field 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
File As Field 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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:44 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft