View Single Post
 
Old 11-23-2019, 06:22 AM
Xiao_Hwu250 Xiao_Hwu250 is offline Windows 7 64bit Office 2007
Novice
 
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