Output report problem

  • Thread starter Thread starter erick-flores
  • Start date Start date
E

erick-flores

Hello there, this is what my report is showing:

Branch Name Customer Name Sales Commission

Houston Chemical $4 $1
Chemical $5 $2
Chemical $4 $1

Atlanta Oil $34 $3
Oil $45
$4
..
..
..

This is what I would like to be:

Branch Name Customer Name Sales Commission

Houston Chemical $13 $4


Atlanta Oil $79 $7

So, basically what I want to do is add those "Customer Name" and sum
the sales and commission for each one.

Can somebody help me pleaseeee

Thank you
 
Create a totals query that groups by Branch and Customer and sums the Sales
and Commission. Base your report on the totals query.
 
Back
Top