Selecting records to print at end of report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CD Tom - 20 Apr 2008 15:58 GMT

I want to select certain records to print at the end of a report. These are
detail records and depending on an event number I want those to print in the
report footer. Is there a way to do this, I was thinking that maybe I could
print a different report on the report footer event but that only print a
complete new report not added on to the original report.
Hopefully this makes sense.
Thanks for any help.

Reply to this Message

Marshall Barton - 20 Apr 2008 16:16 GMT

>I want to select certain records to print at the end of a report. These are
>detail records and depending on an event number I want those to print in the
>report footer. Is there a way to do this, I was thinking that maybe I could
>print a different report on the report footer event but that only print a
>complete new report not added on to the original report.

That sounds like a good time to use a subreport.

Create a separate report that prints the three special
records, then just drag and drop it from the db window into
your main report's report footer section.

Signature

Marsh
MVP [MS Access]

Reply to this Message

CD Tom - 20 Apr 2008 16:32 GMT

Thanks, I didn't even know that there was sub reports. I'll give that a try.

> >I want to select certain records to print at the end of a report. These are
> >detail records and depending on an event number I want those to print in the
[quoted text clipped - 7 lines]
> records, then just drag and drop it from the db window into
> your main report's report footer section.

Reply to this Message