Name is Greg.
I am an intermediate Access user.
What I am trying to do:
I have 2 tables, Parent and Child.
Tables have a relation ship of one -many (Some Parent records have many Child records).
I want to print all Parent records with Child records below the associated Parent.
Looking to format report so that a blank block of space is not under Parent records that have no Child records.
Attached is a PDF showing the format I am looking for (PDF generated with Word).
View attachment Report Exmpl.pdf
When Child records are placed in a second group report filters only Parent records that have Child records. Need to print all Parent records with Child records.
Any time used to help is appreciated.
Thanx
Greg
I am an intermediate Access user.
What I am trying to do:
I have 2 tables, Parent and Child.
Tables have a relation ship of one -many (Some Parent records have many Child records).
I want to print all Parent records with Child records below the associated Parent.
Looking to format report so that a blank block of space is not under Parent records that have no Child records.
Attached is a PDF showing the format I am looking for (PDF generated with Word).
View attachment Report Exmpl.pdf
When Child records are placed in a second group report filters only Parent records that have Child records. Need to print all Parent records with Child records.
Any time used to help is appreciated.
Thanx
Greg