[AccessD] Report Grouping for Financial Years

DenisSherman denis at sherman.org.uk
Thu Sep 18 04:15:55 CDT 2008


Roz,That's it m'dear!  Well done.
The final bit I am now using is this:

FinYr: IIf(Month([ProcessDate])>=4,Year([ProcessDate]) & "/" &
Year([ProcessDate])+1,Year([ProcessDate])-1 & "/" & Year([ProcessDate]))

Thanks a million

Max


On Thu, Sep 18, 2008 at 9:48 AM, <rosalyn.clarke at barclays.com> wrote:

> Hi Max
>
> I don't know of any way to do this other than to specify the financial
> years
> in a dates table (worthwhile if you also need to track financial periods),
> or
> by creating a column with an Iif statement in to bump the record into the
> right year, something like
>
> IIf(Month([RecordDate])>=4,Year([RecordDate])+1,Year([RecordDate])) - this
> assumes your financial year starts on 1st April.
>
> Roz
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo
> Sent: 18 September 2008 09:21
> To: Access Developers discussion and problem solving
> Subject: [AccessD] Report Grouping for Financial Years
>
> 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
>
> This e-mail and any attachments are confidential and intended solely for
> the addressee and may also be privileged or exempt from disclosure under
> applicable law. If you are not the addressee, or have received this e-mail
> in error, please notify the sender immediately, delete it from your system
> and do not copy, disclose or otherwise act upon any part of this e-mail or
> its attachments.
>
> Internet communications are not guaranteed to be secure or virus-free.
> The Barclays Group does not accept responsibility for any loss arising from
> unauthorised access to, or interference with, any Internet communications by
> any third party, or from the transmission of any viruses. Replies to this
> e-mail may be monitored by the Barclays Group for operational or business
> reasons.
>
> Any opinion or other information in this e-mail or its attachments that
> does not relate to the business of the Barclays Group is personal to the
> sender and is not given or endorsed by the Barclays Group.
>
> Barclays Bank PLC.Registered in England and Wales (registered no. 1026167).
> Registered Office: 1 Churchill Place, London, E14 5HP, United Kingdom.
>
> Barclays Bank PLC is authorised and regulated by the Financial Services
> Authority.
>
> --
> 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