Group by year, then by total
- From: jhicsupt <jhicsupt@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 15 Nov 2007 00:24:02 -0800
I want to have a report that shows the orders in the database that have an
order date <2007. I need the report to group by order date <2007, the
highest $ amount first. However I need the report to keep the customers
together. In other words, if ABC Company has total orders in 2006 for
$10,000 and then has other orders in 2007 for $4,000, then the report would
look like:
ABC Company
2006 [Total$]=$10,000
ABC 1 radio Order date 12/1/2006 $5,000
ABC 1 radio Order date 1/1/2006 $5,000
2007 [Total$]=$5,000
ABC 1 DVD Order date 1/1/2007 $5,000
2003 [Total$]=$2,000
ABC 1 ipod Order date 1/1/2003 $2,000
XYZ Company
2006 [Total$]=$8,000
XYZ 1 radio Order date 12/1/2006 $4,000
XYZ 1 DVD Order date 12/1/2006 $4,000
and so on
Hopefully I'm giving you enough information. Thanks so much in advance.
The field names are:
Customer
Order Year
.
- Follow-Ups:
- Re: Group by year, then by total
- From: Allen Browne
- Re: Group by year, then by total
- Prev by Date: Re: records summary report
- Next by Date: Re: Group by year, then by total
- Previous by thread: records summary report
- Next by thread: Re: Group by year, then by total
- Index(es):
Relevant Pages
|
