Queries :: Access 2007 - Merge Two Rows Into One

I am creating a query to use in a Word 2007 mail merge.

For simplicity, let's say the query has three fields:

schname for school name, role for staff role, and name for the staff member's name.

The current query shows:

SchoolA, Admin, Jerry Garcia
SchoolA, President, Bob Hope
SchoolB, Admin, Janet Jackson
SchoolB, President, Mae West

I would like a query that would show one line per school like so:

SchoolA, Jerry Garcia, Bob Hope
SchoolB, Janet Jackson, Mae West

I've looked at Allen Browne's ConCatRelated function and can pull up a list of all names in a field called Expr1001, but that doesn't seem to be what I need.