group sub totals

R

Reggie

i have a report derived from a query, for a group of
agents, the agents collect money from two separate
sources. my report show a total for each agent, which is a
combined total of both sources. i'm trying to figure out
how to put a text box in the header/footer to show the
indivdgual totals for each source for each agent.

can anyone help
 
D

Duane Hookom

=Sum(Abs([Source]="Coerce") * [Amt])
=Sum(Abs([Source]="Brute Force") * [Amt])
 
Top