'Double Loop' in MS Access Report?

Y

yisraelharris

I need to write an MS Access Report which, for a given supplier record
first lists all invoice records for that supplier and then lists al
branch records for that supplier. (Note that although invoice record
and branch records are both related to supplier records, invoic
records and branch records are in no way related to each other.)

If I only had to list all invoice records, I would know how to do it
But with this 'double loop', I have no idea where to start. Any idea
would be welcome
 
J

John Vinson

I need to write an MS Access Report which, for a given supplier record,
first lists all invoice records for that supplier and then lists all
branch records for that supplier. (Note that although invoice records
and branch records are both related to supplier records, invoice
records and branch records are in no way related to each other.)

If I only had to list all invoice records, I would know how to do it.
But with this 'double loop', I have no idea where to start. Any ideas
would be welcome.
Click to expand...

A Report based on the supplier table, with two Subreports - one based
on the supplier invoices and a second based on the branches - would do
this without much difficulty.
 
Top