Conditional statement in summary section

K

Kendra

Good evening,

I am trying to add a summary section which gives total
fees paid. My data is in the following format:

Jurisdiction Land Use Fee Paid
Fremont SF $6650
Fremont MF $4407
Fremont Ind $6607
Long Beach SF $5506
Long Beach MF $4469
Long Beach Ind $6699

I want to be able to put a sum of total fees paid for all
of my cities in one summary section. I tried writing an
if then statment that looks like this:

=if([Jurisdiction]="Fremont",thenSum([Fees Paid]))

Could you please tell me how to fix this statement.

Thanks,
Kendra
 
D

Duane Hookom

If you want to sum each of the jurisdictions in one summary section then
create a subreport that is based on a totals query that sums the FeePaid by
Jurisdiction. Add the subreport to your main report's footer.
 
Top