The IIf expression builder function

[Fons Ponsioen]

What I would recommend is the place the IIF statement in
the underlying query for this report rather than in the
report itself and name it TransX, like
TransX:IIf(TransactionCode = "0083",Sum
([AmountCheck]),TransactionCode)
all on one line. You may not need the Sum() so it would
be:
TransX:IIf(TransactionCode = "0083",
[AmountCheck],TransactionCode)
Again all on one line. Now you can use TransX any where
in the detail or group or report footer with simply
entering Sum([TransX])
Hope this helps.
Fons

-----Original Message-----
I am using the function IIf in a report. The function

works fine in a grouping section. I want to use this same
function in the report footer but it only reads the first
record. At least it seems to be reading the first record
only. Is there a loop function I can use to further the
read for this function. Or am I using this function the
wrong way. My function looks like this.

IIf(TransactionCode = "0083",Sum ([AmountCheck]),TransactionCode)
I am grouping by Transaction code. In my report footer I

want to use this same code to extract 0083 but it won't
read all the way through.