Total on Report (1 Viewer)

[moi]

To all

Is it possible to sum/total Agent, Admin and Marketing Assist separately on Report Footer?. i.e.

=Sum(Agent)
=Sum(Admin)
=Sum(Marketing Assist)

 

[Ranman256]

in the query add these calculations to get amts per CommType:
select [field], AgentAmt: IIf([field]="Agent",[Amt],0) ,AdminAmt: IIf([field]="Admin",[Amt],0)... from table

then sum in the footer:
=Sum(AgentAmt)
=Sum(AdminAmt)