In the Access query generator I am trying IIF statment but having a mental block with the use of Not Isnull.
Com:iif(Not Isnull([Comments],[Comments],"No Comments"))
I have tried various combinations Is Not Null. IsNull etc. So simple but can't get it right. The error occurs with the Not null section