Counting in reports

[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.

 

[Duane Hookom]

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.