Sales Month query

K

Keith

Hi All
I am trying to set up a simple query from a table of data
Here is the structure of the table
Order_num Date Price Salesman_nu
text date currency tex

For the output, I want a table set up as follows
Month Salesman1 Salesman2 salesman3 salesman4 TotalSale

Right now I have the figures broken out by day but can't figure out how to get them to show monthly totals.

Any help is appreciated.

Keith
 
M

[MVP] S.Clark

Month(SomeDate) returns the month number of the datefield.

e.g. Month(#10/18/2000#) = 10

To transpose a single column of data to become mulitple column, you create a
Crosstab Query. Try using the Crosstab Query wizard. Sometimes you will
need to first create a query in which to base the crosstab query upon.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

Keith said:
Hi All-
I am trying to set up a simple query from a table of data.
Here is the structure of the table:
Order_num Date Price Salesman_num
text date currency text

For the output, I want a table set up as follows:
Month Salesman1 Salesman2 salesman3 salesman4 TotalSales


Right now I have the figures broken out by day but can't figure out how to
Click to expand...
get them to show monthly totals.
 
Top