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.