Okay, more questions:
I found out that the Switch function may serve my purposes better as I
discovered more critieria needed to be added. Therefore the control looks
like this now and works beautifully:
=Format(Switch([DispositionType]="Other",[Amt],[DispositionType]="Withdrawn
by Petitioner",[Amt],[DispositionType]="Modified Penalty",[ModifiedPenalty])
& [CSAAmt],"Currency")
However, now I want to total the amounts collected above along with two more
fields: [CSAAmt] & [JudgeAmt] in the
Group Footer. This expression gives me a error telling me it is either
typed in correctly or too complicated - to assign variables:
=Sum(Format(Switch([DispositionType]="Other",[Amt],[DispositionType]="Withdr
awn by Petitioner",[Amt],[DispositionType]="Modified
Penalty",[ModifiedPenalty]) & [CSAAmt] & [JudgeAmt],"Currency"))
I don't know how to "assign variables." Any thoughts?
S. Jackson
S Jackson said:
Oops - got it. Found my answer via "Google." Here is the proper syntax for
anyone interested:
=Format(IIf([DispositionType]="Other" Or [DispositionType]="Withdrawn by
Petitioner",[Amt]),"Currency")
Thanks anyway
S Jackson said:
Unbound text box in my report, control:
=Format((IIf([DispositionType]="Other" Or "Withdrawn by
Petitioner",[Amt],0)),"Currency")
But, it does not work. I puts the [Amt] in every row regardless of
[DispositionType]. Can you put multiple criteria into an If statement? If
so, how do I do this?
TIA
S. Jackson
