View Single Post
 
Old 04-27-2017, 07:57 PM
JennEx JennEx is offline Windows XP Office 2013
Competent Performer
 
Join Date: May 2010
Posts: 162
JennEx is on a distinguished road
Default Adapting Mail Merge Field To Blank Out Empty Instances

Further to this request, based on this helpful solution, I am encountering an issue I hope can be easily overcome.

In my database, if a service is not required, the two times normally displayed are represented simply by hyphens.

In this example posted, there are no services scheduled for sections 2 - 4.

How can I eliminate that format and just leave those fields blank?


image album upload

The textual representation of the mergfield of the highlighted field is:

{ SET A { MERGEFIELD r2_srl \@"AM/PM" } }{ SET B { MERGEFIELD r2_sru \@"AM/PM" } }{ MERGEFIELD r2_srl \@"h:mm" }{ IF A = "AM" "A" "P" } - { MERGEFIELD r2_sru \@"h:mm" }{ IF B = "AM" "A" "P" }
Reply With Quote