'Double Loop' in MS Access Report?

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.


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

On Thu, 3 Jun 2004 05:59:33 -0500, yisraelharris
wrote:


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.

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.

John W. Vinson[MVP]
Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public