Many to Many in Reports - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Many to Many in Reports

William Dowler

6 years ago

Richard,
I have two many to many relationships between Project and Service, and Project and Material, both resolved with junction tables ProjectService and ProjectMaterial. I am finding it difficult to work out how to get these Services and Materials into the same report grouped under a Project. Any advice? Thanks... Bill D.

	Richard Rost @Reply 6 years ago
One to many relationships are easy to display. Just group everything together in a query and use Grouping in your report. Many to many relationships are tough. Most of the time, the only way to properly display them is to use subreports. I cover them in Access Expert 9. I haven't done a TechHelp video on them yet. I'll add it to the (ever expanding and long) list. :)

	William Dowler OP @Reply 6 years ago
Subreports look to be the answer Richard. Many thanks.... Bill D.

	Richard Rost @Reply 6 years ago
My pleasure.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View