sum query

  • Thread starter Thread starter t.y.
  • Start date Start date
T

t.y.

How do I make a query that will show total sales by month
for each sales rep. I'd like to show sales rep name in
the forst column and months in the following columns.
Right now I have a table with three columns: rep name,
date and sales.
 
t.y. said:
How do I make a query that will show total sales by month
for each sales rep. I'd like to show sales rep name in
the forst column and months in the following columns.
Right now I have a table with three columns: rep name,
date and sales.
Click to expand...

Check out the New Query wizard option "Crosstab query".
 
Back
Top