How do I print a report base on it's subreport's sorting.

[eastlaketech]

I have a one to many report based on the FAMILY table with a subreport based
on the STUDENT table. The STUDENT subreport is sorted by grade (youngest
grade first). I need to print labels grouped by the youngest child's GRADE
then TEACHER.

How do I keep the FAMILY/STUDENT records together AND group the main records
based on the subreport sorting (i.e. STUDENT.GRADE then STUDENT.TEACHER then
FAMILY.FAMILY#)?

 

[Duane Hookom]

You need to figure out a way to get the sorting fields/values into the
record source of the main report.

 

[eastlaketech]

Thanks for your response. I looked into creating a query based on the FAMILY
table and the STUDENT table. Then for GRADE, selected MIN and it limited the
records.

I then based the report on the query and was able to use these query fields
to sort the report.

THANKS for making me think differently!