Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2006
    Posts
    47

    Unanswered: Concatenating Multiple Items in a Field into on Field

    Unlike several other post recently, I am trying to combine the Text from a field from several records into one.

    It would look like this.

    Current Records
    Key Colors
    1 Red
    1 Blue
    1 Green

    New Record
    Key Colors
    1 Red; Blue; Green

    I would prefer to do this in a query as it is easier for others to follow. I understand how to do this with Visual Basic.

    Any help would be greatly appreciated.

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    If you know how to do it in code, that's the normal way (a function called from the query). There are also ways to do it in a report, or a SQL way that works in SQL Server.
    Paul

  3. #3
    Join Date
    Apr 2003
    Location
    Alabama, USA
    Posts
    154
    This might help.

    Concatenating unique field values for records matching a query's GROUP BY clause

    Note:
    You don't necessarily have to use a GROUP BY clause. A SELECT DISTINCT SQL statement works as well.

    Hope that helps!
    http://AccessDB.Info

    You live and learn. At any rate, you live. - Douglas Adams

Posting Permissions

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