Results 1 to 8 of 8
  1. #1
    Join Date
    Aug 2010
    Posts
    25

    Unanswered: Concatenation without Query

    Hi,
    Is it possible to concatenate two fields without a query in access. Please help

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    aconcatenandedvalue = "blah" & " de " & "blah"
    anotherconcatenandedvalue = avariable & ", " & [acolumn] & "," & " some text" & "is a mess."
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Aug 2010
    Posts
    25
    I am new. Can you tell me from the begining what is that I need to do to get this working

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    what is 'this' you are struggling with
    what are you trying to do

    the concatenation symbol in VBA is the ampersand &
    so to concatenate its

    destinationvariable = sourceA & sourceB
    destiantionvariable can be a control
    eg mycontrol = sourceA & sourceB
    I'd rather be riding on the Tiger 800 or the Norton

  5. #5
    Join Date
    Aug 2010
    Posts
    25
    Have a table in access and I want to concatenate two fields in that table without a query. I am not using excel.

  6. #6
    Join Date
    Sep 2006
    Location
    Surrey, UK
    Posts
    995
    Provided Answers: 2
    No.

    You can't manipulate the data in a table without using a query, unless you write a VBA subroutine to do it.
    10% of magic is knowing something that no-one else does. The rest is misdirection.

  7. #7
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Quote Originally Posted by sabyds View Post
    Have a table in access and I want to concatenate two fields in that table without a query. I am not using excel.
    how do you expect to get the data out of the table without using a query/SQL?
    I'd rather be riding on the Tiger 800 or the Norton

  8. #8
    Join Date
    May 2010
    Posts
    601
    Quote Originally Posted by sabyds View Post
    Hi,
    Is it possible to concatenate two fields without a query in access. Please help
    Short answer: Not Possible

    Note: Fields are in tables.

    Unless you manually edit a table you use SQL or a query to read and write form a table.

    If you are not referring to fields in a table, please explain in detail what you need.
    Boyd Trimmell aka HiTechCoach HiTechCoach.com (free access stuff)
    Microsoft MVP - Access Expert
    BPM/Accounting Systems/Inventory Control/CRM
    Programming: Nine different ways to do it right, a thousand ways to do it wrong.
    Binary--it's as easy as 1-10-11

Posting Permissions

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