Subreport growth

N

Nelson

Hi

I have a report with a subreport which 'can grow'. I
tried putting my subreport in the section footer of my
report, and I have a page footer with various totals
which is set to show only when me.page = me.pages (ie the
final page of the report). However, when there are many
records in the subreport, and it rolls over onto a new
page Access does not recognise that the extra page has
been created. E.g if there is 1 page but the subreport
forces a second page, access still thinks me.pages is 1
and therefore shows the totals on page 1 and not on page
2. Can anyone help?

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top