[AccessD] Access 2007 Report ?Sort Puzzler?

Charlotte Foust charlotte.foust at gmail.com
Tue Nov 13 13:55:10 CST 2012


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
>
>


More information about the AccessD mailing list