Coding, Access, Winword

[TIDEBED]

I also posted this in Access and regular VB. I hope someone can help me
with this. :-)

I’m fairly new to VB and Access, but I do have other programming
experience. I’ve been trying to implement a reporting strategy from Access
to Word using the Word Mail Merge functionality. As a reference, I’m using
the article called, “Strengthen the Access-Word Connection” by Mark
Johnson in the June 1995 edition of the “Access/Visual Basic Advisor”
magazine. I set up a simple test scenario to make the connections, and
everything seemed to work beautifully. Each record of the query created a
separate Word form letter, just as it was planned. (Hooray!)

But then,........ I tried to use my real world application and I’ve run
into a few snags. I’m not sure if I need to fix this snag using code, or a
different query, or maybe even setting up the Word template differently.
The situation goes like this:

I have an Order #535 where the Customer places orders for several
different items (the quantity of items will vary from order to order). I’d
like to print this order form in Word (because it’s easier for the user to
make changes to the form). The problem is that my query results in a
multi-record answer where Order #535 is repeated for each detailed item
order. (I’ve basically related the items ordered with the Order #535.)

When I mail merge, I get one Order document for each and every item
detail. What I’d like to see as a result, is one Order document listing
all item details. Can someone help me with this? Is my query incorrect, do
I need special code, is my Word template set up incorrectly. HELP?!

Thanks in Advance!!!!!!

Deb :-)