Exporting data from checkboxes

[Guest]

Hello,

I feel like I should have figured this out long ago, but I'm stuck. I'm
using a query as my data source for a mail merge. I'm using Access and Word
2000. Some of the fields are yes/no checkboxes (ie "is it OK for us to call
you at this number?") The merged document is a reference document that
research interviewers would take with them on the interview, and I want the
data to say "Yes" or "No" instead of the TRUE and FALSE values (-1 or 0).
Help?

Thanks a lot!

Karin.

 

[David Seeto via AccessMonster.com]

I don't know much about the mail merge functions with Word, but it seems to me that you should do the merge with a Query that converts the Checkbox value to a Yes/No value using a formula like:

iif([CheckboxFieldName],"Yes","No")

 

[Guest]

I don't know much about the mail merge functions with Word, but it seems to me that you should do the merge with a Query that converts the Checkbox value to a Yes/No value using a formula like:

iif([CheckboxFieldName],"Yes","No")

Thank you! I think that this is probably just what I need.

 

[Guest]

I don't know much about the mail merge functions with Word, but it seems to me that you should do the merge with a Query that converts the Checkbox value to a Yes/No value using a formula like:

iif([CheckboxFieldName],"Yes","No")

Thank you- I'll try that!

 

[Guest]

Thanks for the Help on this one - exacly the problem I was having along with
a simple solution!!
Neville

 

[Guest]

I'm having the same problem importing info from Excel to yes/no field, Is
there a solution that I could apply here?

Thanks for the Help on this one - exacly the problem I was having along with
a simple solution!!
Neville

I don't know much about the mail merge functions with Word, but it seems to me that you should do the merge with a Query that converts the Checkbox value to a Yes/No value using a formula like:

iif([CheckboxFieldName],"Yes","No")