YES/NO Field

D

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.
 
F

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.
Click to expand...

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.
 
D

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.
Click to expand...

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.
Click to expand...

Thank you, that worked perfect.
 
Top