conditional totals in report footers

[sara_fayez]

I want help please ,
i have the following report the heading is company name and some fees i
want to have the toal of fees in report footer one total in case the
company name = A and or b and or c and the total in case company anme =
d and or f and or e
please any one knows answer me

 

[John Spencer]

With the specific example you have given, you should be able to use
something like the following for the source of a control in the report's
footer (not the page footer).

=Sum(IIF([Company Name] = "A" or [Company Name]="B" or [Company Name =
"C",[Fees],0)