Hi All,
I have been struggling to figure out how to write an Iif statement that includes an AND function. in Layman's term what I want is "IF one field is blank AND another filed contains "DT" then put the words "NOT POSTED" in otherwise put "POSTED"
This is what I have tried with no luck..
In certain iterations of the formula when I did get it to work, it bracketed the words in quotations and then asked me to enter a parameter value for those words which didn't work and resulted in it returning a blank value. I am better in Excel than I am in Access and can follow intermediate formulas and functions but this one has me stumped.Code:IIF(([RECON] IS NULL) AND ([SOURCE]=”DT”),”NOTPOSTED,”POSTED”)
Any help is appreciated.