ACCESS FEED: RE: [MS_AccessPros] Finding a financial year.

Senin, 12 September 2011

RE: [MS_AccessPros] Finding a financial year.

Hi Robin

There is no need to populate a field in your table - you can do this easily
with a calculated field in a query:

FinancialYear: Year( [DateField] ) - IIf( Month( [DateField] ) < 7, 1, 0 )

This will give 2008 for any date from 1-Jul-2008 to 30-Jun-2009.

Best wishes,
Graham

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Robin Chapple
Sent: Tuesday, 13 September 2011 15:22
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Finding a financial year.

I have had a great deal of help arriving at an expression that
decides if today is within the financial year 1st July to 30th June.

Now I have a database where a date is recorded when a donation is
made and I need to extract from the entered date which financial
start date it is in.

For instance a recorded date of 23rd February 2009 needs to show as
year commencing 1st July 2008. This will be an extra field in a
query, because it will happen on a remote server, so I need the SQL
that will populate that field for me.

I hope that I have explained sufficiently.

Many thanks,

Robin Chapple