Hi all,
I have a query (qrySAV) with 2 components A and B. I want to create a new one "C" in which If A>0, C=A, if not, C=B
I have tried: IIF ([qrySAV]![A]>0;[qrySAV]![A];[qrySAV]![B])
I am not sure if it is necesary to refer to qrySAV when the elements are in the actual query. When I...