We're a real estate company and I'm tracking all of our properties and which agent(s) are working on each. (There's a lot more than that, but that's all that's playing into my aggravation right now) PropertyInfo table is linked to Agents by a PropCode field. There can be one or more agents per property so it's a one-to-many relationship.
I built a report that's currently grouped by property with the agent names in the "detail" section so it looks kinda like this:
And so on.
What I *want* it to do is give me something like:
Property A Agent A Agent B
Property B Agent C
Is there something I can do with the query or with the properties of the field/report to get multiple agent records to show up on one corresponding property line in the report?