In an Access 2013 Report with totals, I want to make field (a) null if field(b) is not null, but I cannot get my expression accepted in BUILD in the control field.
the following is one of many expressions I have tried unsuccessfully.
Any help would be greatly appreciated.Code:IIf([pmnt2]Not Null=([payment 1])Is Null)
I am on Windows10 (64 bit) using ACCESS2013