Hi all,

I seem to be having some trouble on MS Word 2007 when it comes to merging data from MS Access. What I want is to merge orders based on an Order ID and display the products and price listed for different customers on items they have purchased as an Invoice.

the fields I have in my query are Orders ID, Customer Name, Customer Address, Products Name.