Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Replace True/False with Yes/No in Word Merge from Access Database

Posted on 2008-06-17
7
Medium Priority
?
680 Views
Last Modified: 2012-05-05
The problem exporting Yes/No fields from Access is that they appear in a Word Merge as True/False.  I know it's possible to use an IIF statement in the Word document merge field to change it to Yes/No.  

But when I tried this
{IF {MERGEFIELD "ReviewActioned"} = "True"  "Yes" "No" }

When I merge it writes
ReviewActioned

What have I done wrong?
0
Comment
Question by:Ludique
7 Comments
 
LVL 44

Accepted Solution

by:
GRayL earned 2000 total points
ID: 21805975
use:

Format(ReviewActioned,"Yes/No")

assuming ReviewActioned contains the values -1 or 0 (True or False)
0
 
LVL 44

Expert Comment

by:GRayL
ID: 21805988
In reality, you should export a query to Word rather than the table, in which the field ReviewActioned is replaced by the Format() function above.
0
 
LVL 76

Expert Comment

by:GrahamSkan
ID: 21806098
It's hard to guess what is wrong. I thought you had this working a while ago. I trust that you gave entered the {} pairs with Ctrl+F9 or as a part of entering the field.
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
LVL 76

Expert Comment

by:GrahamSkan
ID: 21806117
Should be: "...I trust that you have..."
0
 

Author Closing Comment

by:Ludique
ID: 31468083
Thank you.
0
 
LVL 46

Expert Comment

by:aikimark
ID: 21806241
What do you mean by 'export'?

I concur with the other experts that you should use a query to format the table data to better suit your needs.
0
 
LVL 44

Expert Comment

by:GRayL
ID: 21806394
Thanks, glad to help
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

971 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question