Microsoft Access reports help:

[abc5432110023]

I have a invoicing report .I have 2 reports .One which prints a
summary of each invoice and another which prints details of all
individual items in a invoice

e.g Report 1 print invoices for all different clients
i.e Client A

Item A $10
Item B $20

Total $30

then
client B
Item C : $10
Item D $20
& so on

Report 2 prints details for each client
i.e for item a of cleint a
04/01/07 : $2
04/02/07 : $2 & so on

for Item B of client A
04/01/07: $2
& so on

Then details for cleint B & so on

How do i combine both these reports to a single reports so that it
prints page 1 as Report 1 then page 2 will be details for that
client
Then next client & so on

 

[traingamer]

Look at subreports, linked on clientId.

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[abc5432110023]

Getting there slowly.Have added teh subreport.
Now i want teh detaisl for each client to start on a new page
For that where shoudl i place teh subreport
e.g main report will be
Invoice number: Amount ..

Signed by ...

Next page should have details for each client.

 

[traingamer]

Put a page break (on the main report) before the subreport.