Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-09-2016, 04:44 AM
JennEx JennEx is offline Mergefield Consisting of Concatenated Strings Windows XP Mergefield Consisting of Concatenated Strings Office 2013
Competent Performer
Mergefield Consisting of Concatenated Strings
 
Join Date: May 2010
Posts: 162
JennEx is on a distinguished road
Default

That worked Paul. It blows my mind that we we were able to concatenate two time strings with simple switches, but to simply use time as itself in a field required a paragraph of formula. (mind you I haven't tried this in the actual report yet ... it may behave quite differently)



How can the A or P for AM or PM be added? I tried the standard method of formatting but it came out looking like this ...

9:30P -10:00P

{IF{MERGEFIELD r1_relchg}<> "" "{MERGEFIELD r1_srl \@ "h:mmA/P"}-{MERGEFIELD r1_sru \@ "h:mmA/P"}"}
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Mergefield Consisting of Concatenated Strings 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
Save merged document as concatenated merge field values texas791 Word VBA 4 02-25-2014 07:35 PM
Mergefield Consisting of Concatenated Strings Search with multiple strings silverspr Excel 7 03-03-2013 04:45 PM
Concatenated data in subsequent rows doorsgirl Excel 4 09-15-2011 10:37 PM
Mergefield Consisting of Concatenated Strings update style of all strings available between two specific strings vikrantkale Word 1 03-28-2011 06:13 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:14 PM.


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