I have a query that has 10 columns with 10 rows/records. 9 of the columns have the same data in each record, one column has item numbers which are all different. What I want is one row showing a quantity of 10, (one for each record) and all of the item numbers from the 10 records concatenated into a new column or Note field.
There are good reasons for doing this. So I won't bother you with them. Suffice to say that there could be 100 records with only 2 or 3 variations but 100 item numbers.
A simpler way to look at it (I guess) is one column of 10 item numbers concatenated into one record In the query, if that is possible