Combining text from rows in the same table

[andrew.munnis]

I need help combining text from two rows in the same table to be output
as a single text string in a report. I have a music db (Access 2000)
with each side of the record a separate row in a Tracks table:

[TrackNo] [Track Title] [Artist]
A my title 1 artist 1
B my title 2 artist 1

I have a report which only prints the A side, [Track No] = A. However
for my purposes some records are classed as double A sides,eg

[TrackNo] [Track Title] [Artist]
A my title 1 artist 1
A my title 2 artist 1
Unfortunately this prints on the report as two separate records in the
Details. I would like the print to be
My Title 1/My Title 2 Artist 1

I'm assuming concatenation would not work here. Any pointers in the
right direction would be much appreciated.

 

[Allen Browne]

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

 

[andrew.munnis]

Thanks. I will give it a go.