Hi,
I have a mail merge query which allows me to pull all the information I need from one particular parent record on one table and add this to a word document. For each parent record there are up to 3 child records from another table that I also need to add to a table in the word document. When the query runs I get up to 3 versions of the parent record depending on how many child records there are, which is what is expected.
The problem with this is that, when I run the mail merge, I get 3 versions of the word document, one for each of the child records.
Is it possible to build a query which will give me the parent record and all the associated child records in one row and so when I run the mail merge I will get one document with all child records in the appropriate table. I created a cross tab query and this did show all the selected child records in one row but I'm not sure what I need to do now.
I've struggled a little to put into words what I want to do so I hope that makes sense. But if there is any more info needed, please let me know. I have included the query below once it runs in case this helps.
I have a mail merge query which allows me to pull all the information I need from one particular parent record on one table and add this to a word document. For each parent record there are up to 3 child records from another table that I also need to add to a table in the word document. When the query runs I get up to 3 versions of the parent record depending on how many child records there are, which is what is expected.
The problem with this is that, when I run the mail merge, I get 3 versions of the word document, one for each of the child records.
Is it possible to build a query which will give me the parent record and all the associated child records in one row and so when I run the mail merge I will get one document with all child records in the appropriate table. I created a cross tab query and this did show all the selected child records in one row but I'm not sure what I need to do now.
I've struggled a little to put into words what I want to do so I hope that makes sense. But if there is any more info needed, please let me know. I have included the query below once it runs in case this helps.