I have an access database which i am trying to merge with MS word form. In the database i have multiple tables which i have queried and combined to one table.
I need to take the information in this table and merge with a word form which takes the Emp_No from the table and prints a form. In this form, i have multiple records for each Emp_No.
Example:
Emp_No. 1 might have 15 individual records (Proj_Comb)
while
Emp_No. 2 has only 3 individual records (Proj_Comb)
I need to have this form print all 15 records for Emp_No. 1 on one page (consecutively)and then move to Emp_No. 2 with their individual records on a separate page and so on and so on through the entire table. The common denominator for each record is the Emp_No field - it is the defined primary key in the database.
If the form didn't require additional formatting once merged i would simply use an access report but it requires that each user has the ability to format to their specifications once merged.
I know this is probably a very simple function i just have not worked enough with word merges to manage it. Any help would be appreciated.
![[noevil]](/data/assets/smilies/noevil.gif "[noevil] [noevil]")
"One of the secrets of life is to make stepping stones out of stumbling blocks." Jack Penn
I need to take the information in this table and merge with a word form which takes the Emp_No from the table and prints a form. In this form, i have multiple records for each Emp_No.
Example:
Emp_No. 1 might have 15 individual records (Proj_Comb)
while
Emp_No. 2 has only 3 individual records (Proj_Comb)
I need to have this form print all 15 records for Emp_No. 1 on one page (consecutively)and then move to Emp_No. 2 with their individual records on a separate page and so on and so on through the entire table. The common denominator for each record is the Emp_No field - it is the defined primary key in the database.
If the form didn't require additional formatting once merged i would simply use an access report but it requires that each user has the ability to format to their specifications once merged.
I know this is probably a very simple function i just have not worked enough with word merges to manage it. Any help would be appreciated.
"One of the secrets of life is to make stepping stones out of stumbling blocks." Jack Penn
