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

Stuart,

Thanks for the help.  You weren't missing anything, but I was.

I have very limited experience with Access sub-reports.

Before today, I had only used a couple sub-reports and they were embedded in the parent's Report Footer section.

I hate to admit it, but I did not know that you could embed a sub-report in a "Group Footer" section with a "tie" to the data in the parent report.

I try to learn at least one new thing every day and you helped me do this today.

Thanks again, I appreciate it.

Brad

   


-----Original Message-----
From: accessd-bounces at databaseadvisors.com on behalf of Stuart McLachlan
Sent: Thu 3/21/2013 4:26 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Interesting Report Request - Adding Notes to anExisting 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
> 


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com