report with subform

[PJ]

Hi All,

I have a main form with multiple subforms, like a name would have multiple
phone numbers and so on. When I create a report to based on names, I will
get 2 pages of report per name if that name has 2 phone numbers, and 3 pages
if that name has 3 numbers. How do create a report to where one name will
list all numbers on one page per name? You help is greatly appreciated.
Thank.

 

[John W. Vinson]

Hi All,

I have a main form with multiple subforms, like a name would have multiple
phone numbers and so on.

When I create a report to based on names, I will
get 2 pages of report per name if that name has 2 phone numbers, and 3 pages
if that name has 3 numbers. How do create a report to where one name will
list all numbers on one page per name? You help is greatly appreciated.
Thank.

If there's only one related table, you can use the form's Sorting and Grouping
dialog. Put the phone number in the detail section, and the other personal
info in the group header and/or footer.

If there are several subtables, use Subreports in the same way that you would
use sumforms on a Form. Base the main report directly on the names table, not
on a query joining the child tables.

John W. Vinson [MVP]

 

[PJ]

Thank you. This works perfectly.