Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2013

    Unanswered: Concatenate & Sort

    Hi, I currently have a query to concatenate several fields

    [field1] & " " & [field2] & " " & [field2]

    However is there a way that when the query combines these field to sort them alphabetically so something like

    field1 field2 field3
    pears apples raspberries

    looks like

    apples pears raspberries

    This also needs to maintain any fields that have a two word entry like
    "sean adams" however sorted by the "s"

    Hope that all makes sense.


  2. #2
    Join Date
    Nov 2010
    If I understand you correctly that you attached is what you wanted?
    Attached Files Attached Files

  3. #3
    Join Date
    Aug 2013
    That is exactly what I am after! Thanks! However I have no idea how to deconstruct this and implement it into my database. I am not an advanced user and as such don't really know much about the SQL module or the union that is there.

    I have a table that has the items listed in the correct order in records. I then run a crosstab query to get them all into one row then use concatenate to make that one field. The problem is that when I run the crosstab query it re-sorts the columns into alphabetical order instead of keeping the order they are in the table. If that makes any sense.

    Sorry to be a newbie >_<

Posting Permissions

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