Concatenate in query

[Rod C]

I have a table with two fields, Number and Text. The number is duplicated multiple times. I want to concatenate the text associated with each number field so that the number shows up only once and the text is concatenated into one record. Is this possible in a query?

 

[RV]

You can't use a query to accomplish this.
You'll need VBA code to loop thru the table for each number.

RV