conditional totals in report footers

  • Thread starter Thread starter sara_fayez
  • Start date Start date
S

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
 
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)
 
Back
Top