After watching the impressive video regarding using the IIF function to change the value of a field, I tried to change it to suit how I would prefer it. By adding a field and condition. But now it says that I have too many arguments. I'd like to know if what I want to do is possible? Basically, I'm adding a "IsBilled" yes/no field. And if this is checked then the box carrying the value would read "INVOICE". I can understand the logic for this not working. Too many true conditions. I just wanted to know if it's possible. Here's what I tried:
Toptext: IIf([ISQUOTED],"QUOTATION",IIF([isbilled],"INVOICE"),IIf([ISPAID],"PAID","INVOICE"))
Thanks in advance!