[AccessD] Access 2007 Report - Sort Puzzler

Brad Marks BradM at blackforestltd.com
Tue Nov 13 15:05:48 CST 2012


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.




More information about the AccessD mailing list