In Access 2002 I am attempting to add text to Field 2 if Field 1 contains any text at all using a query expression.
I have tried innumerable combinations of IIf, Is Not Null, Like using wildcards etc. For example IIf([Composer] is not null), "CA" (Suggested on an MS site) however I can't seem to find the right expression. I know this should be simple so please excuse my dumbness today.
Help greatly appreciated
Peter