[AccessD] Sort order in report

Hi Doris and Ervin

The only way?

I guess you also could create a query grouping on customer and summing
on ordersize (TotalOrdersize).
Then join this with the old query and use it for the source of the
report where you adjust sorting/grouping accordingly: 

  TotalOrdersize DESC
  Customer ASC
  
/gustav


> Sorry...missed the fact that the sum you were using wasn't the total amount
> of items they had ordered.
 
> The only way to do what you want is to create a main report that handles the
> "Customer/Total Amount" sorting and then add a subreport to list the detail
> records for that Customer.
 
> Doris Manning
> Database Administrator
> Hargrove Inc.
> www.hargroveinc.com <http://www.hargroveinc.com/> 

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Ervin Brindza
> Sent: Wednesday, September 03, 2003 8:17 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Sort order in report


> Doris,
> sorry but no success :(
> My report looks like:
> 1. Mike Thompson

>     1. plum 155

> 2. Ervin Brindza

>     1. orange 100

> 3. Ervin Brindza 

>    1. apple 80

> 4. Mike Thompson

>          1. orange 40

> even I put the Customer name in the SumOfAmount's header or in
> Customer.Name's header the result is the same :(