Results 1 to 5 of 5
  1. #1
    New Lounger
    Join Date
    Jul 2003
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Concatenate (1.2)

    How can I use the concatenate function within Access. Thanks for your help.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Concatenate (1.2)

    If you want to concatenate two string expressions, use &

    For example, in a query:

    FullName: [FirstName] & " " & [LastName]

    If this is not what you wanted, please explain what you mean by the concatenate function.

    Oh, and by the way, what does the 1.2 version number in the subject stand for?

  3. #3
    New Lounger
    Join Date
    Jul 2003
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Concatenate (1.2)

    Here is the function I have built in expression builder:
    concatenate([Input Tab I]![L/N Indicator],[Input Tab I]![Risk Type],[Input Tab I]![LN-FAC-(YES/NO)])

    I get an undefined function 'concatenate' in expression.

    Any words of wisdom.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Concatenate (1.2)

    Ah, I think that you are confusing Excel and Access. CONCATENATE is a worksheet function in Excel, but it is not a function in Access. In fact, you don't need it here, you can concatenate strings by placing & between them:

    [Input Tab I]![L/N Indicator] & [Input Tab I]![Risk Type] & [Input Tab I]![LN-FAC-(YES/NO)]

  5. #5
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Concatenate (1.2)

    There isn't any standard Access function named concatenate. If you want to concatenate string data, you do it as Hans indicated. Thus you would do

    MyNewString = Input Tab I]![L/N Indicator] & [Input Tab I]![Risk Type] & [Input Tab I]![LN-FAC-(YES/NO)]
    Wendell

Posting Permissions

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