Summing specific fields on a report

[spacekowboy]

Hi, in the footer of my report I have a
field that sums the Transaction Amounts - =Sum([Transaction Amount])

I would also like to break the totals down further by Transaction Type Codes.

Something like =Sum([Transaction Amount]) where Transaction Type Code = AL-Exp-Paid



Can someone help me with the syntax for this?

Thanks

[Xipooo]

You need to put groups on your report.

http://www.youtube.com/watch?v=uVHez5A6v0I

[pbaldy]

Or this type of thing:

=Sum(IIf([Transaction Type Code] = "AL-Exp-Paid", [Transaction Amount], 0))

But if there are several a subreport based on a totals query would be more dynamic.

[spacekowboy]

pbaldy, it looks like that will work! Much appreciated

Or this type of thing:

=Sum(IIf([Transaction Type Code] = "AL-Exp-Paid", [Transaction Amount], 0))

But if there are several a subreport based on a totals query would be more dynamic.

[pbaldy]

Happy to help!