Many to Many reporting problems

[ljm]

Project for a touring company. This involves a few files: Trip Master, Clients, Hotels

Issue - How to report the clients for each hotel, associated with a trip, when all the hotels share the same trip code (I can add unique ids)

I need to create this report in the client db, because there is a lot of special sorting that goes on to get them to appear in the correct room order. But I can't find a way to move from one hotel to the next, throughout the trip, showing the same client list. (Except when I run the report from Hotels using a portal, which doesn't allow me to sort the names and add formattming separating them correctly)

I have tried join tables, but can't sort by hotels and then by client criteria, on the report.