Please forgive me if similar questions have been posed elsewhere. I looked through several pages and am unsure what to search for. My situation is this:

I need to construct a query based on three tables: tblSeminars, tblInstructors, and the joining table--tblInstructorsSeminars.

I want to list the seminar instructors for each seminar, but I want each seminar to be a distinct row in the query.

My problem is that sometimes a seminar will have two instructors, which means two entries on tblInstructorsSeminars, hence two rows on a normal Select query.

This is probably very basic, but some guidance, or a shove out the door, would be greatly appreciated.

Is this the kind of thing you're looking for?

http://www.mvps.org/access/modules/mdl0004.htm

It might be. I'll check it out. Thanks for the lead.

Brodie