asked on

Merging Data from a query

HI,

I have a database (MS Access 2003), until recently I had 1 table with pupil names and addresses which I merged with MS Word 2003 and all worked fine. I have now had to split the table as pupils can have more than one Parent at different addresses. So, I have a 1-many relationship between pupil and address table.

I have created a query to bring all the data together but now when I try and merge it I only get 1 record rather than 180 as there should be.

I have searched loads of web sites tried all sorts of connotations of queries and word docs. Any suggestions appreciated.

Tricia

Barry Cunney

As a once off make the 'created query to bring all the data together' a Make Table query to get a table with the required format.
Then change this query to an Append Query for future runs.
Make the newly created table the source for the mail merge.

So the going forward you will need 2 steps(which can possibly be automated with VBA)
1. Clear out the table with merge address details
2. Run Append query to populate above table.

The do the merge

GrahamSkan

That would be a one-to many query. Word's Mail merge needs a one-to-one query. I have listed some alternatives here.
https://www.experts-exchange.com/questions/23658368/Doing-a-mail-merge-with-section-breaks-using-a-specific-value.html

If you want help or further assistance with any of the workarounds, let us know.

Tricia McKeating

ASKER

Struggling to understand any of the solutions maybe the best solution is not to use Word and just design reports like the main documents?

ASKER CERTIFIED SOLUTION

GrahamSkan

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial