T
toadflax
Hi,
I have a report in Access 2002 which generates receipts for payments.
The query it's based on pulls out records for payments between a given
date range and with an "email receipt" field being set to Yes. I
generate the report and then "print" it to PDF995, which gives me one
receipt per page of a multi-page PDF. I then break it into individual
PDFs with burstpdf for attachment to separate emails.
What I'd like to do is combine two receipts which are for the same
person ("member name", which is the primary key in the table) onto one
page before turning them into PDFs. The report only fills half a page,
so there's room, but I can't work out any way to make the report be a
single page for a single receipt/person but also for two receipts to
the same person. Perhaps I could have two queries and two reports, but
then I think the non-sequential numbers of the receipts from each
query would mess me up in what's already a rather too complicated
process!
Is there any way to make this happen? I'd be very grateful for any
help. I have probably explained this pretty badly, so please let me
know if you need more information.
Cheers,
Michelle
I have a report in Access 2002 which generates receipts for payments.
The query it's based on pulls out records for payments between a given
date range and with an "email receipt" field being set to Yes. I
generate the report and then "print" it to PDF995, which gives me one
receipt per page of a multi-page PDF. I then break it into individual
PDFs with burstpdf for attachment to separate emails.
What I'd like to do is combine two receipts which are for the same
person ("member name", which is the primary key in the table) onto one
page before turning them into PDFs. The report only fills half a page,
so there's room, but I can't work out any way to make the report be a
single page for a single receipt/person but also for two receipts to
the same person. Perhaps I could have two queries and two reports, but
then I think the non-sequential numbers of the receipts from each
query would mess me up in what's already a rather too complicated
process!
Is there any way to make this happen? I'd be very grateful for any
help. I have probably explained this pretty badly, so please let me
know if you need more information.
Cheers,
Michelle