Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 05-31-2019, 03:30 PM
JennEx JennEx is offline If Mergefield Not Displaying All Values Windows XP If Mergefield Not Displaying All Values Office 2013
Competent Performer
If Mergefield Not Displaying All Values
 
Join Date: May 2010
Posts: 162
JennEx is on a distinguished road
Default If Mergefield Not Displaying All Values

I am needing a second set of eyes. I apologize for not beiung able to copy and paste the true mailmerge field here. I cannot get GMayors Export Field Constructioins addin to work.




{ if { MERGEFIELD R2_SRL }<> "" {MERGEFIELD r2_srl \@ "h:mm"}-{MERGEFIELD r2_sru \@ "h:mm"}P " " }


Should display, for example "1:30-2:00P" if there is a value for rs_srl. If not, the field is empty. What I am getting instead, when s2_srl = 1:30 PM (a true time), is "1:30"


Something wrong with my field? A space missing perhaps, or in the wrong spot? Too many spaces?


Both fields rs_srl and s2_sru have values in the database.
Attached Files
File Type: docx msof_DT15NG.docx (34.7 KB, 6 views)

Last edited by JennEx; 06-01-2019 at 08:55 AM.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Help Displaying Values and Linking GourdoftheFries Excel 2 01-03-2019 01:19 AM
Table with values from several locations and years - need to find comp values Ricardo Sousa Excel 9 07-27-2018 02:06 AM
If Mergefield Not Displaying All Values Table with values from several locations and years - need to find comp values Ricardo Sousa Excel 6 06-09-2018 10:51 PM
Display multiple values as new values based on selection from template. MvdB Excel 2 09-29-2015 08:51 PM
If Mergefield Not Displaying All Values Printing selected pages based on a MERGEFIELD.g. If MERGEFIELD=x then print pages 1,2,4 if MERGEFIEL Richard.p Word 3 04-21-2015 01:14 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:09 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft