Two Queries / One Report

'Two queries / one report' seems to be a common topic, but I still can't find the information I need.

Normally I am pretty good at finding answers through google or by searching a forum like this one, but in this case I don't know exactly what I'm looking for help on.

Let's say I have two tables that look like this:

Employees
---------
ID
Name
Hire Date


Absence
-------
ID
Date
Reason


So there is a one-to-many relationship and the tables link on ID.

I want a report in which each page looks a little something like this:

=====
Name: John Smith
ID: 123

Absences:
Dec 12, 2006 sick
Dec 18, 2006 car trouble
Dec 22, 2006 cat died
=====

I think that putting all these fields into a single query and feeding that into a report would give me a separate page for each absence, would it not?

I see the word "subreport" thrown around now and then, maybe that is what I'm looking for, with two queries . . ? :confused:

In case it matters, there are a couple other associated tables similar to Absences that I would like to include later on, so I'm looking for a solution that will work with more than one linked table.

Any help would be greatly appreciated. Thanks very much in advance.

-SD