MS Access: Generating a Mail Merge with Supervisory Data

[CRGreathouse]

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?

 

[CRGreathouse]

I'm no SQL wizard, but I was able to code the appropriate snippet for 'Row Source' to link each piece of equipment to a supervisor (by their ID):

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

But to make the (report?) that I want, I'm not sure where to start in Access.

 

[Greg Bernhardt]

I haven't used Access in years so I can't help much. But this looks like a pretty good tutorial on reports.
http://databases.about.com/od/tutorials/l/aareports1.htm