subreport between each entry on the report

[Radhika]

I have created a report that has entries 1,2,3 and 4. I want to add a
subreport which has 2 more entries. However, when i try to do so, the entries
for the subreport show up in between those on the report. This is not what i
want. I want the subreport entries to show up below those of the main report.
How do i do this.

Radhika

 

[John Spencer]

Put the subreport in the report footer.
or
Put the subreport in a group footer that is printed after your details



--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Radhika]

Thanks! I Put the subreport in the report footer, but it only shows me one
entry as opposed to two..i tried changing the size of the detail section, but
that did not work. Is there any way i can fix this?

Radhika

 

[John Spencer]

Is the sub report linked to the main report via the detail fields? Is so,
you need to make a change to the sub report so it is not linked via the
field limiting it to the current record and you will probably need to change
the subreports underlying query.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Radhika]

Thankyou! That was very helpful.

Is the sub report linked to the main report via the detail fields? Is so,
you need to make a change to the sub report so it is not linked via the
field limiting it to the current record and you will probably need to change
the subreports underlying query.

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..