In Microsoft Access XP I have a table called Assignments with fields called Project and Person. There are multiple people assigned to each project. I would like a query to roll up to one line for every Project with a field that lists all the people assigned to each project.