Creating a list, from a LINK (Join) table, for use in Mail Merge

[Graham T]

I am creating a mail-merge application.

The data stored will be dealing with Students and Qualifications that they have attained. The link table in the relationships shown/attached, allows a Student to have multiple qualifications.

When I merge the data, I will need to list all of the qualifications that each student has attained, which will need to be either in a item list, or in a comma-separated list.

The list will need to be pulled from the link table (StudentQualifications). For example:

StudentID #1 >> Qualification #1 Description
StudentID #1 >> Qualification #2 Description
Etc
Etc

So, when the data is merged, it will specify that:

StudentID #1 has acheived Qualification #1 and Qualification #2 and Etc, Etc.

How can I create this list in the first place, which can then be used in the source of the merge for the document.

Any ideas as to how I can pull multiple information into either a single string to pass to the merge or into a list in the document would be appreciated.

Graham

 

[Jon K]

You can use VBA code to update a temporary table for mail merge.

I have attached a sample database. You can open the form and click on the command button to update the table "tblTemp".

The code is in the On Click event of the command button. It uses the data in the query "qryQualificationsAchieved" to update the temporary table.
.

 

[Graham T]

Jon

Thanks very much for the example.

Looks to do pretty much what I needed, much appreciated.

Graham