Hi,
I have the following example as records in a query. Only a few fields are
listed for this example.
Title Author
Book A Author A
Book A Author B
Book A Author C
Book B Author X
Book C Author Y
Book C Author Z
Book D
So as you can see a book can have either no authors, 1 author or more than 1
author.
Right now, the report shows multiple lines when there is more than 1 author. On my report I would each record to be displayed only on 1 line in the details section like this:
Book A Author A, B, C
Book B Author X
Book C Author Y, Z
Book D
How can this be done. I am not a programmer so please try to simplify the
explanation.
Thank you
Liane
I have the following example as records in a query. Only a few fields are
listed for this example.
Title Author
Book A Author A
Book A Author B
Book A Author C
Book B Author X
Book C Author Y
Book C Author Z
Book D
So as you can see a book can have either no authors, 1 author or more than 1
author.
Right now, the report shows multiple lines when there is more than 1 author. On my report I would each record to be displayed only on 1 line in the details section like this:
Book A Author A, B, C
Book B Author X
Book C Author Y, Z
Book D
How can this be done. I am not a programmer so please try to simplify the
explanation.
Thank you
Liane
