Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
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
Reply



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 03:05 AM.


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