Printing multiple reports at once

[Soundje]

Hello,
I want to print mulitple reports with different content based on a query.
It is like printing invoices of different customers based on a date selection at once/ automated

Current I have it working so that I have to select 1 customer at the time...
Any ideas who I should be starting?


Many thanks for any sugestions
Koen

 

[jdraw]

It sounds like you need a query involving at least 2 tables Customer and Invoice.
Once you get the query working. Use that query as the record source of your report.
You can set up the report to produce 1 Invoice per page or whatever you need.

Do not overlook Google (or Bing) to search info on query with > 1 table, or Access Report recordsource and/or access report samples.

These links may be helpful to your project:
http://databaseanswers.org/data_models/customers_and_invoices/index.htm
http://office.microsoft.com/en-ca/access-help/HV080203281.aspx
http://www.fontstuff.com/access/acctut19.htm

 

[Soundje]

Hello jdraw,
First of all my excuses for the delayed answer but due to end of the year holidays i was not able to answer earlier..

I have my query ready as much as possible; here is already a extraction of it;see attachment..

just some more informations:
I want to have a report (invoice) for each "contractID" separate, but printed automatic; it can be on *.pdf as well if this is easier, i was thinking to do the trigger for each report in VBA but have no idea how to start on the code...

Any idea?

Many thanks,
Koen

 

[jdraw]

You have multiple records for contractID --- how do you bring these records together for invoicing/reporting? Are these records LineItems on an Invoice?
Have you tried to put this data onto a Form Or Report?

Can you post a jpg of the report format you are planning to use?

 

[Soundje]

The multiple records for contractID are handled as LineItems within the same invoice..

I have included inthe attachment some screenshot for the reports that I am currently already using, this is already working fine,
The thing that I still need to find a solution for this the automatic printing of each invoice and this 1 invoice for each "group" of contractIDs.

I hope this is a littlebit more clear if not please let me know..

Many thanks for all your help and time.

Br,
Koen

 

[jdraw]

Do you have an Invoice Table? How do you relate InvoiceID and ContractId?

 

[Soundje]

See attachment for the relations,

Thanks
Koen

 

[Soundje]

Hello,
I have tried myself some things:
I am able to create the report based on the correct query all information is in one report (see attachment knipsel.jpg)
I marked the lines in yellow these are the header, what I want is to have for "each" header a new report that includs each time the totals in the footer..

I als included a screenshot of the report that I created (knipsel2.jpg)

Thanks,
Koen