Word merging from access to word

[bochs]

Hi all,

i have an employee personnel table and a qualifications table in my database that i am trying to merge into a word document. the personnel file contains the following fields which will be used: first_name, last_name and badge_#. The qualifications table then relates a qualification type (job_id) to a badge_#. This table is necessary because each employee can have multiple qualifications.

My problem is when i go to create the merge it will make a separate document for each unique combination of badge_# and job_id, however I would like it to only make 1 document per badge_# and then fill out all job_id's that specific employee is qualified for.

 

[bochs]

Found these links that helped but still ran into some problems with them not being experienced in data merging:

http://cornell.veplan.net/article.aspx?&a=3815

http://support.microsoft.com/kb/294686/

I ended up going a different route however... I ran a cross tab query that out of access and got a series of 0's and 1's for each qualification; 0 being did not have qualification, 1 being did have qualification.

I exported this query to excel, wrote some vba code and got all the qualifications of each specific employee listed in a single cell in the same row as the rest of the employee's data as follows:

Qual 1
Qual 2
Qual 3
Qual 4

I then used a simple mail merge to generate all of my letters, if anyone else has this type of problem let me know and i can help you find a work around too : ]