Brad Marks
BradM at blackforestltd.com
Tue Nov 13 14:10:57 CST 2012
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.