Have you considered using grouping, which would allow you to very easily
produce a report which looks like:
Comment 1
ActionA
ActionB
ActionC
Comment 2
ActionD
ActionE
....
Click the "Sorting and Grouping" button (it's the one with some brackets and
lines on it) on the Report Design toolbar to give you access to the dialog
box. Enter/select the Comment field in the Field/Expression, and enter Yes
in Group Header in the Group Properties section in the lower portion of the
dialog. Then put the control for your Comment field in the Comment group
header section of the report, and the control for the Action field in the
detail section.
HTH,
Rob
"Mark Carter" <ca**********@ukmail.com> wrote in message
news:36*************@individual.net...
I have a database in which there is a one-to-many relationship between
comments and actions. I would like a report that looks like:
Comment1 ActionA
ActionB
ActionC
Comment2 ActionD
ActionE
...
but I can only seem to produce:
Comment1 ActionA
Comment1 ActionB
Comment1 ActionC
Comment2 ActionD
Comment2 ActionE
...
What do I need to change?
Does it involve fiddling around with sub-reports?