Grouping records by supplier
Hi!
Is there a way to merge multiple fields from a database into the body of a letter in Word, grouped by the supplier and listing all supplier's items, like shown in the example belove?
Supplier 1
Address 1
..... some text here.....
Item 1 is approved for use
Item 2 is approved for use
Item 3 is not approved for use
.
.
.
Item xx (all items of the supplier listed here)
....some text here....
The database consists of the following fields:
Supplier name
Supplier address
Item name
Approval
Supplier Name Supplier Address Item Name Approval
Supplier 1 Address 1 Item 1 approved for use
Supplier 1 Address 1 Item 2 approved for use
Supplier 1 Address 1 Item 3 not approved for use
Supplier 2 Address 2 Item 1 approved for use
Supplier 3 Address 3 Item 1 approved for use
Supplier 3 Address 3 Item 2 not approved for use
.
.
.
.
Supplier XX Address XX Item XX not approved for use
|