 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Importing / Linking / August 2006Exporting data from checkboxes
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. 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") > 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. > 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! 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") 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!! [quoted text clipped - 3 lines] > > > > iif([CheckboxFieldName],"Yes","No") |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.