[Doug Robbins - Word MVP]

I would do it all in Access.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Jpod" wrote in message
ups.com...
Hi,

I have two tables in Access 2003 with a one-to-many relationship, in
an access report the grouping works, how do I make this work in a Word
2003 mail merge? The following are not my tables but an example of
what I am trying to achieve, where the relationship is 1 to many from
Orders to OrderItems:

Table 1 - Orders
OrderID
Date
SalesPerson

Table 2 - OrderItems
ItemID
Description
QTY
Value
*OrderID

On the 1 Page word document I want to print display as follows

This is your Order ID on Date.
Your Salesperson was Salesperson.

Here is a list of your Items:
ItemIDDescriptionQTYValue



It will list as many items as there are for the particular OrderID.Any
help gratefully received. I have tried various methods but can't seem
to get any to work.

Many Thanks, Chris.