Try adding a Query in Access to restructure the data. In SQL view this might look like this
Code:
SELECT Person, "Comm 1" AS Committee
FROM Table1
WHERE (((Committee1)=True));
UNION ALL
SELECT Person, "Comm 2" AS Committee
FROM Table1
WHERE (((Committee2)=True));
UNION ALL
SELECT Person, "Comm 3" AS Committee
FROM Table1
WHERE (((Committee3)=True));
You should be able to use that query as your merge source (or use it as the basis for an Access Report)