Concatenating several records of the same field

[Guest]

In my report I need to concatenate values of the same field but different
records (the output being something like "This month we've got orders from A,
B, C, D, F, Y, MM", A, B, C etc. being the values of the different records of
the same field). As I understand, "&" operator won't do it (it only
concatenate fields within the same record)

 

[Allen Browne]

See:
Return a concatenated list of sub-record values
at:
http://www.mvps.org/access/modules/mdl0004.htm