ACCESS FEED: Re: [MS_AccessPros] Re: Sub-report with a subreport

Minggu, 24 April 2016

Re: [MS_AccessPros] Re: Sub-report with a subreport

Robin-

The field in Link Master is the field used from the outer report to match the value in the field specified in Link Child. How can a Unit ever match a Count? That's why you see nothing in the subreport.

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications

SQL Queries for Mere Mortals

http://www.viescas.com/

(Paris, France)

On Apr 24, 2016, at 2:42 AM, Robin Chapple robinski@westnet.com.au [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:

Thanks John,

OOOPS! Further examination has found:

Link master field to unit

Link child field to count of first name.

Regards,

Robin

At 23/04/2016 07:54 PM, you wrote:

Robin-

Open your report in Design View and open the Properties window. Select each subreport and tell us what you see in the Link Master Fields and Link Child Fields properties.

Also, what is the Record Source of the three reports?

John Viescas, Author
Microsoft Access 2010 Inside Out
Microsoft Access 2007 Inside Out
Microsoft Access 2003 Inside Out
Building Microsoft Access Applications
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)

On Apr 23, 2016, at 5:59 AM, Robin Chapple robinski@westnet.com.au [MS_Access_Professionals] < MS_Access_Professionals@yahoogroups.com> wrote:

Thanks Bill,

I have been away for other projects and have just returned to this pro blem. Please forgive my ignorance but I do not know what to check with the master/child links. What am I looking for?

Robin Chapple

At 19/04/2016 12:14 AM, you wrote:

Robin
Check you master/child links. If all looks okay, build a test query with the record sources from all three reports and see what you get.

Bill Mosca

---In MS_Access_Professionals@yahoogroups.com, <robinski@westnet.com.au > wrote :

Access 2013. I have a report which includes a sub-report. This works
as planned. When I add that report as a sub-report to a third report
the data from the first sub-report is missing. The labels are present.

What have I missed?

Robin Chappple