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

Sounds like a standard sub-report to me. Or am I missing something?

Just create a report on the notes table and embedded it in the JobNbr group footer with 
the parent/child field properites set to Job-Nbr.

-- 
Stuart

On 21 Mar 2013 at 13:58, Brad Marks wrote:

> 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
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>