count records in subform

D

David#

I have a table listing peoples' names and a table containing their kids (and
kid's data).. These are populated via a Form (Cients) and subForm (Children)

I also have a tabular report... each row represent an Parent with field data
from main form. I need to count the Children per each parent on this report.
I'm stumling arouind with DCount, but getting no where. Can this be done?

Thanx - David
 
D

Duane Hookom

Can you provide some information about your table structure and report
record source?
Do the children display in your report? Or, are they displayed in a
subreport?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Retrieving data from multiple records 2
print last record of 1-to-many relationship 7
Including records with null values in report 8
Populate main form from subform record 0
Suppressing Report Headers or How to Report/DisplayParent/Child/Granchild relationships 4
Macro with an IF/OR statement 10
count in parent report footer 2
Count, Dcount, or Ab(Sum())? 3

Top