YES/NO Field

[debbiep]

I have a yes/no field in my database. I am trying to merge this field
into a word document. The results are coming up TRUE and FALSE. How
can I change the value to say YES or NO in my mailmerge word document?
In the database the data type is yes/no.

 

[fredg]

I have a yes/no field in my database. I am trying to merge this field
into a word document. The results are coming up TRUE and FALSE. How
can I change the value to say YES or NO in my mailmerge word document?
In the database the data type is yes/no.

In the query that you are using as the source of the data to merge
into word, add a new column:
MyCheck:IIf([OldCheck]=-1,"Yes","No")

Use this column in the merge data.

 

[debbiep]

I have a yes/no field in my database. I am trying to merge this field
into a word document. The results are coming up TRUE and FALSE. How
can I change the value to say YES or NO in my mailmerge word document?
In the database the data type is yes/no.

In the query that you are using as the source of the data to merge
into word, add a new column:
MyCheck:IIf([OldCheck]=-1,"Yes","No")

Use this column in the merge data.

Thank you, that worked perfect.