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 >