Results 1 to 4 of 4
  1. #1
    DanielHurtubise is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2011
    Posts
    5

    Adding a space in a concatenation in 2010


    Hi everyone,
    i tried to add the " " but it doesnt seem to work on 2010 anymore.
    String is simple [FirstName] & [LastName] but i would need a space in between.

    Thanks for your help

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,870
    I don't have 2010, but Firstname & " " & Lastname would seem appropriate.
    Did you get an error?

  3. #3
    DanielHurtubise is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2011
    Posts
    5
    You rock
    I was missing the second &

    Thank you so much, you should see the smile on my face

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,870
    Glad to help. Are you the DanielHurtubise from IC?

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

Similar Threads

  1. Adding a space between fields with hyperlink
    By JeffG3209 in forum Programming
    Replies: 5
    Last Post: 05-04-2011, 08:35 AM
  2. Query and Concatenation
    By Try2Live4God in forum Programming
    Replies: 2
    Last Post: 05-25-2010, 03:45 PM
  3. Concatenation of Text and Number
    By diane802 in forum Reports
    Replies: 67
    Last Post: 01-26-2010, 03:37 PM
  4. Concatenation and IIF statements in report
    By bjsbrown in forum Reports
    Replies: 20
    Last Post: 10-19-2009, 10:00 AM
  5. Concatenation Urgent Help
    By Shoaib in forum Queries
    Replies: 0
    Last Post: 04-23-2009, 11:02 PM

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