Report Format (Details) 1

[EasyOnly]

I am designing a report that I need to have two detail sections. I have about 3 tables as row sources. two of the table relate to the first one (one to many relationships) I need to have the report lookinglike this:

Name:John Smiith

First table records:
There maybe or or few

Second table recrods......

I thought that I can do this by having two detail section in the report. Any suggestions?

Thanks

 

[dhookom]

Use a main report of one of the one-to-many and place subreport in the Group Header or Footer of the one. An alternative would be to create a report based on the one and two subreports based on the manys.

Duane
Hook'D on Access
MS Access MVP