[AccessD] Change Order within Access 2007 Report Group

I once added a toolbar to a report like this and used VBA to group the
report according to the user choice from the toolbar. It was easy -- I
thought maybe I'd written about it and looked for an online article, but
didn't find one. Might be something to write about. It would be easy to add
sort options to a custom group that opens with the report I would think.

Susan H.

On Tue, Dec 9, 2014 at 5:33 PM, Charlotte Foust <charlotte.foust at gmail.com>
wrote:

> 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
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>