# MS Access

Homework Helper
I'm trying to make a simple database in Access (to replace an older one in Filemaker), but I'm not sure how to do what I want.

I have a table of workers, each of which is tied to a supervisor. (At the moment they're both in the same table with a flag to tell supervisors from other workers, but this could change if convenient. The database keeps the same kinds of information on both kinds of workers, so there didn't seem to be a good reason to split them.)

I want to generate a mail merge with a letter for each supervisor, including information on each worker supervised. Is there a good way to do this?

## Answers and Replies

SELECT [Workers].[Worker ID], [Workers].[First], [Workers].[Last] FROM Workers WHERE (((Workers.[Supervisor?])=Yes)) ORDER BY [Last], [First];