Results 1 to 2 of 2
  1. #1
    Bakar is offline Novice
    Windows Vista Access 2007
    Join Date
    Dec 2010
    Posts
    4

    Full Name in field


    Hi Everyone
    I want to know what to do to have the full name
    in fieldC using first name in fieldA and last name in fieldB
    (as concatenate in excel)

    Thanks

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    You would use a calculated field in a query to concatenate the two fields.
    FullName: [Firstname] & " " & [LastName]
    You do *not* want it in the table.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Full App - Mileage/Timesheet Example
    By pkstormy in forum Sample Databases
    Replies: 9
    Last Post: 05-27-2015, 03:37 PM
  2. Full App - Cardfile Application
    By pkstormy in forum Sample Databases
    Replies: 0
    Last Post: 08-24-2010, 07:23 AM
  3. Print full page
    By divdav in forum Access
    Replies: 3
    Last Post: 05-23-2010, 07:00 PM
  4. Run time vs Full Version
    By softspoken in forum Access
    Replies: 5
    Last Post: 04-29-2010, 08:15 AM
  5. I can't get a full outer join to work
    By Bobt1993 in forum Queries
    Replies: 3
    Last Post: 03-20-2010, 10:05 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums