acss said:
I have a report on country invoices and within the Report Footer section,
there is the control for a grand total
=Sum([SumOfInvAmt])
How do i get the grand total just for one country such as for example
"BRASIL".
Thanks
It's quite easy - you need to track down the "sorting and grouping"
button on the toolbar, and group by Country. Then (as you've no doubt
done for the report footer) add a control whose ControlSource is set to
=Sum([SumOfInvAmt]).
Note that you can get problems if one of the amounts is null, so it's
worth extending that to:
=Sum(NZ([SumOfInvAmt],0))
NZ replaces nulls with 0 (or whatever you choose).
Of course, you could simply adjust the report's underlying query (or
apply a filter in code), so that only records from Brazil are included.
Phil, London