Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-22-2019, 07:20 PM
Xiao_Hwu250 Xiao_Hwu250 is offline Using AND in field codes for two mergefields Windows 7 64bit Using AND in field codes for two mergefields Office 2007
Novice
Using AND in field codes for two mergefields
 
Join Date: Nov 2019
Posts: 3
Xiao_Hwu250 is on a distinguished road
Default Using AND in field codes for two mergefields

Hi there,



I'm having problems making my merge fields condition based on two requirements. I want a couple of text to show if the city is Quebec and if there is a receipt number and another kind of text to show if the city is not quebec and the receipt is not blank. If there is no receipt number at all then a different text would show. I've tried the combination below but it keeps showing what it would show if it was quebec and receipt combination only. Any help would be greatly appreciated. TIA
Attached Images
File Type: png Screen Shot 2019-11-22 at 8.28.31 PM.png (31.2 KB, 13 views)
Reply With Quote
  #2  
Old 11-23-2019, 05:06 AM
macropod's Avatar
macropod macropod is offline Using AND in field codes for two mergefields Windows 7 64bit Using AND in field codes for two mergefields Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Try something based on:
{IF{MERGEFIELD City}= "Quebec" {IF{MERGEFIELD Receipt_Number}= "" "Output for Quebec without Receipt_Number" "Output for Quebec with Receipt_Number"} {IF{MERGEFIELD Receipt_Number}= "" "Output for Not Quebec without Receipt_Number" "Output for Not Quebec with Receipt_Number"}}
or:
{IF«City»= "Quebec" {IF«Receipt_Number»= "" "Output for Quebec without Receipt_Number" "Output for Quebec with Receipt_Number"} {IF«Receipt_Number»= "" "Output for Not Quebec without Receipt_Number" "Output for Not Quebec with Receipt_Number"}}

Do note that, if the Receipt_Number mergefield generates numeric output, you'll need to change the "" expressions to "0" or 0.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 11-23-2019, 06:22 AM
Xiao_Hwu250 Xiao_Hwu250 is offline Using AND in field codes for two mergefields Windows 7 64bit Using AND in field codes for two mergefields Office 2007
Novice
Using AND in field codes for two mergefields
 
Join Date: Nov 2019
Posts: 3
Xiao_Hwu250 is on a distinguished road
Default

Thank you, Paul. Yes, receipt number is numeric. Should I then insert 0 into all places where receipt number is present as well as not present? i.e

{IF«City»= "Quebec" {IF«Receipt_Number»= "0" "Output for Quebec without Receipt_Number" "Output for Quebec with Receipt_Number"} {IF«Receipt_Number»= "0" "Output for Not Quebec without Receipt_Number" "Output for Not Quebec with Receipt_Number"}}

thanks again
Reply With Quote
  #4  
Old 11-23-2019, 06:31 AM
Xiao_Hwu250 Xiao_Hwu250 is offline Using AND in field codes for two mergefields Windows 7 64bit Using AND in field codes for two mergefields Office 2007
Novice
Using AND in field codes for two mergefields
 
Join Date: Nov 2019
Posts: 3
Xiao_Hwu250 is on a distinguished road
Default

Thank you, Paul. Yes, receipt number is numeric. Should I then insert 0 into all places where receipt number is present as well as not present? i.e

{IF«City»= "Quebec" {IF«Receipt_Number»= "0" "Output for Quebec without Receipt_Number" "Output for Quebec with Receipt_Number"} {IF«Receipt_Number»= "0" "Output for Not Quebec without Receipt_Number" "Output for Not Quebec with Receipt_Number"}}

thanks again
Reply With Quote
  #5  
Old 11-23-2019, 01:21 PM
macropod's Avatar
macropod macropod is offline Using AND in field codes for two mergefields Windows 7 64bit Using AND in field codes for two mergefields Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Please read the previous instructions - there is no provision for 0s where the receipt # is not present. Your revised field code is correct.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using AND in field codes for two mergefields VBA Code to search for field codes with certain text before the Field code and to change style welcometocandyland Word VBA 4 02-08-2017 06:53 PM
Using AND in field codes for two mergefields IF in field codes? tinfanide Word 1 09-15-2016 06:19 AM
Using AND in field codes for two mergefields New to Field Codes Panzer336 Word 2 04-11-2016 07:57 AM
Using AND in field codes for two mergefields Need help with Field Codes Cosmo Mail Merge 25 07-30-2015 01:25 PM
Formula Field using Field Codes hunter2193 Word 3 04-05-2013 04:58 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:23 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