philwes83170
MIS
I need to create a view to summarize actual totals of orders by sales rep. It's got to be easy but, I'm a novice programmer so I keep getting lost.
My table looks like this:
Name Order Amount Date
Smith ABC 100 12/1/2005
Smith XYZ 200 12/15/2005
Smith QWE 500 1/15/2006
Jones LMN 150 1/5/2006
I need a view that will show the following:
Name FiscalYear FiscalQtr Total
Smith 2006 1 300
Smith 2006 2 500
Jones 2006 2 150
Our fiscal year is Oct 1 to Sept 30. I've got the totals for each rep, but I don't know how to break it out to the year and quarter.
Thanks in advance for your assistance.
My table looks like this:
Name Order Amount Date
Smith ABC 100 12/1/2005
Smith XYZ 200 12/15/2005
Smith QWE 500 1/15/2006
Jones LMN 150 1/5/2006
I need a view that will show the following:
Name FiscalYear FiscalQtr Total
Smith 2006 1 300
Smith 2006 2 500
Jones 2006 2 150
Our fiscal year is Oct 1 to Sept 30. I've got the totals for each rep, but I don't know how to break it out to the year and quarter.
Thanks in advance for your assistance.