[AccessD] Report Grouping for Financial Years

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