Variable number of entries per field in contact report
in [Reports]
|
Prev: Order Totals (From Expression) on summary report
Next: How to create a report border that changes color w/each new secti
From: crabbymom on 20 Jan 2010 09:03 Hi, I'm not a db programmer, so this is painful. I'm creating a directory for our church. Singles, couples, families. I've got it all working except that if a family has more than one child, the family is getting one report entry for each child. How do I format the control so that if there are multiple children, all are printed in a horizontal field at the bottom of the family's entry? I have the children in a subtable with two fields, Child and Birthdate. They're linked to the ID of the family's db entry in the main table.
From: Duane Hookom on 20 Jan 2010 09:12
The no code solution is to build a multi-column subreport for the children and place it in the family section and link on the ID of the family. -- Duane Hookom Microsoft Access MVP "crabbymom" wrote: > Hi, > I'm not a db programmer, so this is painful. I'm creating a directory for > our church. Singles, couples, families. I've got it all working except that > if a family has more than one child, the family is getting one report entry > for each child. How do I format the control so that if there are multiple > children, all are printed in a horizontal field at the bottom of the family's > entry? I have the children in a subtable with two fields, Child and > Birthdate. They're linked to the ID of the family's db entry in the main > table. |