count related records only

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

Guest

I have a report that shows detail only from a head of household query. The
report also has a subreport that lists the related records (family members)
from another query. I need the detail section of the main report to count the
records that are displayed in the subreport. I tried using the dcount
function, but I don't know how to write the criteria so that it counts only
the related records. I am counting a primary key field that is named ID.
TIA.
 
You can place the Count in the report footer of the subreport. Then you can
add a control in the main report with a control source like:
=srptCtlName.Report!txtCount
 
Back
Top