query on many to many

[jges]

I have books and procedures, books contain multiple procedures and a procedure can be in more than 1 book. I have 3 tables set up: books, procedures, and a join table. My input form works well. So far, so good.

Now, I would like to set up a query/report that lists each procedure in a given book and the other book(s) (if any) that each procedure appears in. I have a query that lists each procedure in a given book and another that lists each book that contains a given procedure. Any advice on combining them?

I would like output something like:
Book1
Procedure 1
also in: book 3
Procedure 2
Procedure 3
also in: book 2
also in: book 3

Book 2
Procedure 3
also in: book 1
also in: book 3
Procedure 4
.
.
.

 

[dhookom]

You could possibly use a subreport for the "also in:".

If you can live with
also in: book 1, book 3
I would use faq701-4233 to concatenate the also ins.

Duane
Hook'D on Access
MS Access MVP

 

[jges]

Your concatenate function looks promising, thanks for pointing me to that.