Sabtu, 23 April 2016

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


Thanks John,

OOOPS! Further examination has found:

Link master field to unit

Link child field to count of first name.



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



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
(Paris, France)

On Apr 23, 2016, at 5:59 AM, Robin Chapple [MS_Access_Professionals] <> 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:

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, < > 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


Posted by: Robin Chapple <>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (7)

Upgrade your account with the latest Yahoo Mail app
Get organized with the fast and easy-to-use Yahoo Mail app. Upgrade today!



Tidak ada komentar:

Posting Komentar