Counting in reports

  • Thread starter Thread starter Roger Bell
  • Start date Start date
R

Roger Bell

I have several fields in a data base for entering
childrens names. I want the system to total the number
of children for each record. The fields are Text fields
and I don't believe the count will work. Is there any
other way and thanks.
 
Children are usually kept in a "child" table that is related to a
"family/parent" table. The number of children is the Count() of records in
the child table where the familyId in the child table matches the FamilyId
in the parent table.
 
Back
Top