[AccessD] Sort order in report

Ervin Brindza viner at eunet.yu
Thu Sep 4 01:32:53 CDT 2003


----- Original Message -----
From: "Gustav Brock" <gustav at cactus.dk>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: 03 September, 2003 3:34 PM
Subject: Re: [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,
great idea!  I'll try to join the queries!
Many thanks, yuo are a lifesaver :)
    Ervin




More information about the AccessD mailing list