Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 06-27-2024, 06:59 PM
Guessed's Avatar
Guessed Guessed is offline MailMerge field for decimals with letters, i.e. 1A.23 Windows 10 MailMerge field for decimals with letters, i.e. 1A.23 Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,186
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Looking at what you provided, it appears that you could compare SubLocation against a formatted ItemNumber. Do you have a larger data set which includes rounded numbers for us to test on?

I did have a fiddle with the one entry and you might be able to try something along the lines of testing formatted vs unformatted eg
{If {MERGEFIELD ItemNumber \# ##.##} = {MERGEFIELD ItemNumber } {MERGEFIELD ItemNumber } {MERGEFIELD ItemNumber \# ##.##}}
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
 

Tags
mailmerge



Similar Threads
Thread Thread Starter Forum Replies Last Post
Ref field to Database field doesn't update properly in Mailmerge huynguyen865 Mail Merge 1 08-30-2021 07:30 AM
MailMerge field for decimals with letters, i.e. 1A.23 Macro to insert an image to a word mailmerge document based on the value of a mailmerge field? Jake93 Mail Merge 3 07-02-2019 05:38 PM
Mailmerge field format? Rothera85 Mail Merge 9 05-11-2014 03:41 PM
Words & letters half burried in a Text field in a table. Ed54 Word 4 01-05-2012 04:10 PM
mailmerge with letters of a different numbers of pages roel1972 Mail Merge 0 02-21-2011 11:45 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:53 PM.


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