I have an instance where It's like this on a report:

Title (grouped by)

Detail: Artists Song Number.

Everything works fine, except when there is the same artist and title
I want it to do this:
example

Title (grouped by)

Detail: Artist Song Number 1 Song number
2 Song number 3, etc

The way I have it now it is like this:

Title (grouped by)

Detail: Artist Song Number 1
Song Number 2
Song Number 3

How do I get it to show across if the title and artist are the same?

On 15/09/2011 09:00:43, chrisdavis wrote:
I suspect you need to create a CrossTab query, then you will need to do some
research on how to produce a dynamic crosstab report. The problem is that
until the query has run, you don't know how many columns (Songs) your report
is going to need.

Phil

"Phil" <phil (AT) stantonfamily (DOT) co.uk> wrote in
news:j51n7k$ha$1 (AT) speranza (DOT) aioe.org:

Dev Ashish wrot a function called fConcatChild, and published it at
http://access.mvps.org/access/modules/mdl0004.htm

It would be a workable solution to the original poster's problem.

--
Bob Q.
PA is y I've altered my address.