[AccessD] Change Order within Access 2007 Report Group

The simplest way is to have two groups on the same values, one sorted one
way and the second sorted the other.  Then just show or hide the group
depending on what the user wants.

Charlotte

On Tue, Dec 9, 2014 at 1:48 PM, Brad Marks <bradm at blackforestltd.com> wrote:

> All,
>
> Is it possible to change the order in an Access report Group from "with A
> on top" to "with Z on top" with VBA code?
>
> We currently have an Access 2007 report that our Accounting Department
> uses daily.  This report has one report "Group" on Sales_Order_Number
> (Ascending).
>
> Recently it was requested that a second report be created with the
> Sales_Order_Numbers in descending order.
>
> Instead of creating a second report, I would like to have a button to
> change the Report's Group Order on the fly.  Is this possible via VBA code?
>
> We have several other reports where the sort order is changed on the fly,
> but none of these have report Groups.
>
> Thanks,
> Brad
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>