Jim Dettman
jimdettman at verizon.net
Tue Nov 13 15:18:43 CST 2012
Brad, <<If a query is built *only* for the purpose of supplying data to a report, then the "Sort" at the query level is useless. I am having a little bit of trouble wrapping my head around this. I might have some brain damage from many years of COBOL and DB2 :-)>> That is correct and is true of just about any report engine (not just Access) that has any type of grouping built in. Think RPGII<g> Jim. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks Sent: Tuesday, November 13, 2012 04:06 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Access 2007 Report - Sort Puzzler Stuart, Yes, I can't believe that I haven't stumbled on this before now. As we say here in Minnesota "UFF DA!" I guess that most of the reports that I have worked on have "sorts" and don't rely on the query for the order of the records. I will need to check into this more closely, however. If a query is built *only* for the purpose of supplying data to a report, then the "Sort" at the query level is useless. I am having a little bit of trouble wrapping my head around this. I might have some brain damage from many years of COBOL and DB2 :-) I learned something new today and I am very grateful to the AccessD folks who provide insights and answers. Brad -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan Sent: Tuesday, November 13, 2012 2:33 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Access 2007 Report - Sort Puzzler It's *always* been that way in Access. If' you've never encountered it before, you've been very lucky. -- Stuart On 13 Nov 2012 at 14:10, Brad Marks wrote: > Charlotte, > > Thanks for the help. > > What you wrote explains why I am seeing these results. > > This really surprises me! I thought that reports would receive data > from the query in the order that is shown when a person looks directly > at the query. I also thought that reports would show the data in the > same order as they receive it. (I was wrong) > > I really appreciate the insights. This is good info to know. > > I was starting to pull my hair out on this one :-) > > I owe you a big margarita ! > > Brad > > > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte > Foust > Sent: Tuesday, November 13, 2012 1:55 PM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Access 2007 Report ?Sort Puzzler? > > Reports ignore the underlying query sort. You have to use sorting and > grouping on the report or apply the OrderBy and OrderByOn options to get > what you need. > > Charlotte > > On Tue, Nov 13, 2012 at 9:07 AM, Brad Marks > <BradM at blackforestltd.com>wrote: > > > All, > > > > I have a small test application that is yielding strange results that > I > > cannot figure out. > > > > There is only one table and one query. > > > > The query is sorted on a field called "Customer Name". > > > > This works fine. > > > > There are two reports. The original report keeps showing the data in > > order by "Sales Order Number". > > > > When I go into Design View for this report, I cannot see any "Group" > or > > "Sort" for this report. > > > > Just for fun, I used the Report Wizard to set up a second report (also > > with no sorts). This second report returns the data correctly. (in > the > > same order as the underlying query). > > > > I must be missing something. I have run many tests and cannot see > what is > > causing this problem. > > > > Has anyone else seen this happen? > > > > Thanks, > > Brad > > > > -- > > AccessD mailing list > > AccessD at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/accessd > > Website: http://www.databaseadvisors.com > > > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > -- > This message has been scanned for viruses and > dangerous content by MailScanner, and is > believed to be clean. > > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com