Hi, I'm attempting to categorise my data using nested IIf AND functions in query design but it's not working. Can anyone help?
Priority: IIf([ColumnA] = "*abc*","P1",IIf(([ColumnA]="*def*") And ([ColumnB] Is Not Null),"P2"),IIf(([ColumnA]="*def*") And ([ColumnB] is null, “P3")