'Double Loop' in MS Access Report?

  • Thread starter Thread starter yisraelharris
  • Start date Start date
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
 
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.
 
Back
Top