Query for mailing

[habiler]

Hello to all,

I have a table including fields candidate, Chairman, assessor1 and assessor2. By mailing I would want to print (3X) an including document on the one the name of the Chairman, on the second the name of the Assessor 1 and on the third the name of the Assessor 2 with on three documents the name of the candidate. How do I have to take myself there to create a query including these elements?

Thank you for your help.

Habiler

 

[vbaInet]

I have a table including fields candidate, Chairman, assessor1 and assessor2.

How do I have to take myself there to create a query including these elements?

Habiler, your table already contains the fields that you require. What kind of document are trying to create?

 

[habiler]

It is about a Word document

 

[vbaInet]

It would have been easy to do a mail merge if you have properly structured tables with one of them in this format:

CandidateID	ChairOrAssessorID
-----------	-----------------
1		1 - represents Chairman
1		2 - represents Assessor1
1		3 - represents Assessor2

With your current (not so ideal) structure, you would have to build a union query to create the above structure. More info on a Union query here:

http://www.fabalou.com/access/queries/unionquery.asp