I just tried this and did not get an error.
Code:
IIf([bstat]="Increase","Please note the pending increase.","Please note the pending decrease of " & Format([decrAmt],"Percent"))
& (IIf([bstat]="Increase",""," from the last decrease which was " & Format([decrAmt],"Percent")) & ". ")
I deleted a couple of extra "&".... added the space inside the preceding string.
The open/close parenthesis's before the second IIF() are not needed (in RED above):
Code:
IIf([bstat]="Increase","Please note the pending increase.","Please note the pending decrease of " & Format([decrAmt],"Percent"))
& IIf([bstat]="Increase",""," from the last decrease which was " & Format([decrAmt],"Percent")) & ". "
The easiest way to ensure the correct paring of parenthesis is to count the number of open parenthesis and the number of close parenthesis.