I have the following data for which I need an iif function and can't quite figure out the syntax.
this data changes so tomorrow it may be
I need an iif statement that will do the following:
iif ([name]="John Smith", "Update", "ADD")
the problem i'm having is I ONLY want to do this for John Smith. I can't set the criteria of [Name]="John Smith" because that defeats the purpose of the iif statement..
basically, if John Smith appears today, regardless of who else is in the field today, then I want to update another field but if John Smith does not appear today I want to add the field.
I hope that's not confusing and appreciate your help.