Document Merge

[Stephenlyn]

Hi Everyone

I have a database that contains details of students and various options that those studentys are taking. The options are selected by clicking on a check box. The problem I have is that I want to merge these results into a form letter in Word and I don't want the check box result I want the text information associated with the check box to appear in the Word.

Does this make sense?

Any ideas?

regards

Steve

 

[Durkin]

Try building a query that converts the True/False values into strings eg.

SELECT StudentID, IIF(Option1 = TRUE, 'Option1 is True', 'Option1 is False) AS strOption1 FROM Table1;

Then merge the query with the word doc. Durkin
alandurkin@bigpond.com