[AccessD] Report Grouping for Financial Years

Aha!  I didn't know you could do that.  Thanks Gustav.  As you will see from
my reply to Roz, I have now sorted it.Thanks very much for the input.  Learn
something every day!
Max


On Thu, Sep 18, 2008 at 10:09 AM, Gustav Brock <Gustav at cactus.dk> wrote:

> Hi Max
>
> - in the small box, Sorting and Grouping. Insert that line as the
> expression.
>
> /gustav
>
> >>> denis at sherman.org.uk 18-09-2008 10:54 >>>
> Thanks Gustav,I can't quite get my head around how I put this into the
> Grouping options in the Report.  The income records extend back over a few
> years and I need to report on how much income each fundraiser has generated
> by financial year.
>
> Thanks
> Max
>
>
> On Thu, Sep 18, 2008 at 9:36 AM, Gustav Brock <Gustav at cactus.dk> wrote:
>
> > Hi Max
> >
> > You can group by the financial year:
> >
> >  =Year(DateAdd("m", -3, [YourDate]))
> >
> > /gustav
> >
> > >>> max.wanadoo at gmail.com 18-09-2008 10:21 >>>
> > Hi,I am trying to create a report based on Financial Years grouping.  The
> > default grouping gives Calendar Years.
> > Is there anyway I can group by Financial Years (1 April to 31st March).
> > Thanks
> > Max
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>