Sales Month query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top