[AccessD] Report Grouping for Financial Years

DenisSherman denis at sherman.org.uk
Thu Sep 18 03:54:33 CDT 2008


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
>



More information about the AccessD mailing list