A
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.
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.