Article View: comp.databases.ms-access
Article #536Re: Driving Me Nuts!!!
From: Vincent Quesnoit
Date: Wed, 09 May 2001 10:24
Date: Wed, 09 May 2001 10:24
32 lines
3170 bytes
3170 bytes
The "group By" in the report just adds the group header and page footer to every group. When you design the report you tend to put the fields that are grouped upon in the group header, but this is not mandatory, and you can display them in the detail section if you like. If you set the report such that group headers and footers are not displayed, you will get sorted records. HTH, Vincent James a οΏ½crit : > Access reports do their own sorting based on the sort fields you specify in > the Sorting and Grouping dialog of a report. The recordsource Order By > clause is then ignored. > > My problem is the following: > > In the application I am creating, I allow the user to choose which fields to > sort by... I then use the following code in the Report_Open procedure... > > Me.GroupLevel(0).ControlSource = field > Me.GroupLevel(1).ControlSource = field > Me.GroupLevel(2).ControlSource = field > > This code changes the Sorting and Grouping order for the report, but > unfortunately it 'Groups By' instead of 'Orders By'. I did a little > research and found that this only happens when dealing with reports. (Not > queries, etc.) - Found this information in the VBA help. > > Does anyone have any suggestions on how I can dynamically specify an "Order > By" clause to the Report when it opens?
Technical Details
Message-ID:
<3AF91AD8.85120101@evidian.earth.sun.milkyway.universe.com.invalid>Path:
arc1-ca.pugleaf.net!newsfeed.google.com!sn-xit-02!supernews.com!news.gv.tsc.tdk.com!news.iac.net!news-out.cwix.com!newsfeed.cwix.com!skynet.be!freenix!teaser.fr!rain.fr!norma.bull.net!tosca.bull.fr!not-for-mailReferences:
<9KXJ6.235669$Z2.2529860@nnrp1.uunet.ca>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII X-Google-Thread: fb7cd,211f97db499caa4f X-Google-Attributes: gidfb7cd,public X-Google-Thread: 114549,211f97db499caa4f X-Google-Attributes: gid114549,public X-Google-Thread: 1143dd,211f97db499caa4f X-Google-Attributes: gid1143dd,public X-Google-Thread: 10f31b,211f97db499caa4f X-Google-Attributes: gid10f31b,public X-Google-Thread: ff0ac,211f97db499caa4f X-Google-Attributes: gidff0ac,public X-Google-Thread: 113291,211f97db499caa4f X-Google-Attributes: gid113291,public X-Google-Thread: 10c7bc,211f97db499caa4f X-Google-Attributes: gid10c7bc,public X-Google-Thread: 11315a,211f97db499caa4f X-Google-Attributes: gid11315a,public X-Google-ArrivalTime: 2001-05-09 03:59:42 PST Path: arc1-ca.pugleaf.net!newsfeed.google.com!sn-xit-02!supernews.com!news.gv.tsc.tdk.com!news.iac.net!news-out.cwix.com!newsfeed.cwix.com!skynet.be!freenix!teaser.fr!rain.fr!norma.bull.net!tosca.bull.fr!not-for-mail From: Vincent Quesnoit <vincent.quesnoit@evidian.earth.sun.milkyway.universe.com.invalid> Newsgroups: comp.databases.ms-access,free.database.access,microsoft.public.access.activexcontrol,microsoft.public.access.chat,microsoft.public.access.commandbarsui,microsoft.public.access.conversion,microsoft.public.access.customcontrols,microsoft.public.acces Subject: Re: Driving Me Nuts!!! Date: Wed, 09 May 2001 12:24:24 +0200 Organization: Another Netscape Collabra Server User Lines: 33 Message-ID: <3AF91AD8.85120101@evidian.earth.sun.milkyway.universe.com.invalid> References: <9KXJ6.235669$Z2.2529860@nnrp1.uunet.ca> Reply-To: vincent.quesnoit@evidian.earth.sun.milkyway.universe.com.invalid NNTP-Posting-Host: frcls6245.frcl.bull.fr Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Mailer: Mozilla 4.7 [fr] (WinNT; I) X-Accept-Language: fr