[AccessD] custom sorts/groups in a report

Rocky Smolin - Beach Access Software bchacc at san.rr.com
Tue Apr 20 10:19:21 CDT 2004


Right.  Except when I need to sort or group on an unbound control.  That's
when I have to add it to the query and bind the control to that field in the
query.

Rocky

----- Original Message ----- 
From: "Gustav Brock" <gustav at cactus.dk>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Tuesday, April 20, 2004 7:53 AM
Subject: Re: [AccessD] custom sorts/groups in a report


> Hi Rocky
>
> > When I run into this problem I have to add the calculation to the query
> > that's the recordsource for the report.  Then I can group and sort on
it.
>
> Hmmm ... you should sort in the report, not in the query (except for
> the sorting caused by grouping, of course).
>
> /gustav
>
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>




More information about the AccessD mailing list