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.

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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.
>

Thanks. I will give it a go.