Working with Access trying to create a report with a subreport

Question

I am working with basketball stats (girls high school - many seasons). I have 3 queries that I 'need'.(a) v1 - list of girls with sisters that have played - varsity, reserve and/or freshman(b) v21 - list of points scored by individuals at the varsity level(c) v31 - list of points scored by the sisters combinedEach query includes a sister_code.&nbsp; (Most of the players do not have a sister_code)I have created a report showing the (i) code, (ii) Last name, (iii) total points and (iv) number of sisters.I am (trying) to create/link a subreport to each detail line of my report that then shows the scoring for each of the individual sisters.&nbsp; (When I am finished the sister_code will NOT be visible.)My 'ideal' report will look like:Most points scored by sisters at the varsity levelSis_code&nbsp; &nbsp; Name&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Points&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;SistersSmi&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Smith&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2500&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3&nbsp; &nbsp; &nbsp; Smi&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Amy Smith&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1200&nbsp; &nbsp; &nbsp; &nbsp; 1984-87&nbsp; &nbsp; &nbsp;Smi&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Beth Smith&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 900&nbsp; &nbsp; &nbsp; &nbsp; 2000-02&nbsp; &nbsp; &nbsp;Smi&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Chris Smith&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;400&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1992-95JL&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Jones&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2200&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp;Deb Jones&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1300&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2007-10&nbsp; &nbsp; &nbsp;Ellie Lopez&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;900&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2013-16&nbsp; &nbsp;&nbsp;Right now I get my report to print 'nicely'.&nbsp; But, my sub-report prints all of my 60 sisters, not just the 2 or 3 from the detail.Yes, my sub-report is the reports detail part.&nbsp; BUT I have not done anything to limit(link) my sub-report.&nbsp; What do I need to do?

tom_van_stiphout · Answer

The subreport control has LinkMasterFields and LinkChildFields properties. Read up on them.

Forum Discussion

Working with Access trying to create a report with a subreport

Resources