calculated control based on criteria on a report

[hlkelly]

I have a report grouped by expense detail. Each detail has certain criteria (cash or credit card). I have a total of the overall expense report on the report footer but I would like two other totals: Cash and Credit card. How can I get all three totals to appear on the form? I can't figure out the syntax.

Thanks!

 

[PHV]

Have a look at the IIf function:
Sum(IIf(criteria='Cash', amount, 0))

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886