Alternative to grouping?

[johnnixon]

(Using Access97) Resubmitting this one in the hope that I have now formatted it OK. Am trying to create a tabular report with a matrix of lines (like in a Word table). Where there are multiple entries, I would like to concatenate them into a single row, with the first column entry shown only once. If I group on the first column entry, remaining columns then appear one row down, including where there are single entries. So I want:-

Da Vinci Code         Bill Smith
                      John Doe (with Bill Smith and John Doe in the one cell)
Dartmoor Guide        Mary Smith
The Listeners         Dan Willis

What I get:-

Da Vinci Code
                      Bill Smith
                      John Doe
Dartmoor Guide
                      Mary Smith
The Listeners
                      Dan Willis

As you've guessed, my knowledge of reports wouldn't fill a space this big. I suspect that the solution won't be grouping, but some code which can look at previous record/this record and blank or concatenate. Anybody had this problem before?
Any advice much appreciated

Regards

John

 

[johnnixon]

Pat

Thanks a lot - very good of you. A quick glance at the MS article looks very promising. Will have a studious look at it later when I finish work.

Kind regards

John

 

[johnnixon]

Hi Pat

Further to my previous rushed reply, this is exactly what I was looking for. It will only need a little bit of editing to modify it for multiple columns. I certainly wouldn't have found that link by myself.

Thank you once again for your very helpful contribution.

Kind regards

John