Concatenating Elements from Same Field

[ybur]

Novice: Building a report in CR 8.5 within VB 6 that is to take several author's first and last names (2 separate fields in tblAuthor) per book (many to one relationship). Using Access 97 database. I need to show all of the authors of a book in the following bibliographical format: LastName, FirstName, FirstName LastName, FirstName LastName, et al. I have been using the Formula Editor, then dragging and dropping the field onto the report.

I have been searching through the forum and cannot seem to relate my problem to those that are using parameters to concatenate the elements.

Hoping for some advice . . . .

 

[xn55]

I am not sure if this is what you are looking for, but:

1. Create a new formula.
2. Go to the "Operators" window. Click "+" next to string.
3. 2X click on the "Concatenate". You then insert the fields you want to concatenate (one infront of the + and the other behind it).

 

[ybur]

Straight concatenation I've got; however . . . .

In my layman's terms: the primary key in one table is the title of the book and it can have several authors linked to it from the author table. I need to display all of those authors in one line in the report, as described in my original question.

Perhaps I need to loop to look for all occurrences of authors for that title?