![]() |
|
#6
|
|||
|
|||
|
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" } |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Adding sequential Number in a document that already has merged fields inserted
|
Highlander01 | Mail Merge | 3 | 01-19-2016 12:33 PM |
| Time allotted minus time used with result in hour and minute | esther6086 | Excel | 2 | 04-29-2014 05:03 PM |
| Formatting Merged Time Values Between Excel & Word | JennEx | Mail Merge | 1 | 07-12-2012 02:54 PM |
| combined in-box for webmail accounts | sonoman | Outlook | 1 | 07-19-2011 02:50 PM |
| word and excel combined | jasperman | Word | 1 | 08-23-2010 06:49 AM |