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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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#)?
 
You need to figure out a way to get the sorting fields/values into the
record source of the main report.
 
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!
 
Back
Top