[AccessD] Interesting Report Request - Adding Notes to an Existing Access 2007 Report

All,

We have an existing Access 2007 Report which shows "Routing Info"
(Manufacturing Firm).

The data is stored in an SQL-Server Database which is accessible via
ODBC.

This report currently shows one line for each "Process Step" for each
Job Number.

There are several fields for each Process-Step, but for this example I
will only show two fields 
(There is a report "Group" on Job-Nbr)


~~~~~~~~~~~~~~~~~
Job-Nbr     Process-Step
M1000          010
M1000          020
M1000          030
M1000          040
~~~~~~~~~~~~~~~~~

It is possible to attached one or more "notes" to each Job-Nbr via the
data entry system.  These notes are stored in a separate database table
with the Job-Nbr as the Primary Key.

Recently there has been a request to add these notes to this report as
shown below.  

~~~~~~~~~~~~~~~~~
Job-Nbr     Process-Step
M1000          010
M1000          020
M1000          030
M1000          040
This is note-1
This is note-2
This is note-3

~~~~~~~~~~~~~~~~~

I am starting to experiment with approaches to add the notes to this
report.

I am curious if others have ever run into something like this.

Thanks,
Brad