Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2008
    Posts
    150

    Unanswered: Combining Text with Concatenated Fields

    Hello,

    I have two fields that I have concatenated in a query (below). How can I add a word in front of each Region Number?

    =[RegionNumber]&" - "&[Region]

    Example: Region 100 Los Angeles

    Thank you.

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    = "a word" & [RegionNumber]...
    Paul

  3. #3
    Join Date
    Sep 2008
    Posts
    150
    Thank you so much Paul. That work out well.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •