sum query

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.
 
R

Rick Brandt

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".
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert Data in One Table from Another Table 2
Columnheadings 3
Difficult Query; Trying to Show only One Record for only Two Field 1
Help With a Query; Using Expression Builder 12
Cross Join - Please Help! 5
Code Check Request - Query to find reused values 2
Queries & calculations 4
Union Query with a Crosstab Query 17

Top