Sum Problem (Footer)

[racer25]

Hi

I Have a debtors listing that has multiple currencies and is grouped by the Account Manager.

In thr Group Footer (or somewhere) I would like to put the total, the problem is that I need a total for each currency.

I have attached a sample which shows the data and the problem report.

I am trying to avoid using a subreport as one of the requirements is that I be able to filter the main report by value due and still get the subreport totals to be correct.

I am using Access 2007 but have attached sample in 2000 to hopefully cater for everyone.

If anyone needs more info please let me know.

Cheers,

Rob

 

[pbaldy]

One way:

=Sum(IIf(CAC_CURRENCYCODE = "EUR", SumOfInvoiceBal, 0))

But a subreport based on a totals query would be more dynamic.