fiscal/financial year

R

RG

How do I add a function or does anyone have the function to place the
financial year in a database?
I am just feeling my way through access 2007 at the moment and have some
database experience.

RG
 
B

Bob Barnes

I use a Dropdown to select a FY (Fiscal/ Financial) Year...then populate 2
unbound textboxes for the "From" & "To" Dates of the FY. IE...if FY 08
starts on 5/1/07...The "From" will be 5/1/07 and the "To" will be 4/30/08. I
use those Dates in Queries to find selected FY data.

HTH - Bob
 
R

RG

Essentially I require the year for example fiscal year 2008 to be from 1st
July 07 to 30 jun 2008. Then as I move into next year i.e. 1 July 08 it says
in my field that the financial year is 2009 etc automatically.
I am not sure if your method works for it

I am assuming that something like this if(current date)>=1 st July 07 and <=
30 June 08 then fy=2008 but how do I get it to automatically kick in for the
next fy?
I am sorry I only have some database experience and sometimes things need to
be spelled out a little for me.

thanks again

RG
 
B

Bob Barnes

I am assuming that something like this if(current date)>=1 st July 07 and <=
30 June 08 then fy=2008 but how do I get it to automatically kick in for the
next fy?

Bob ---> Run the code above on the Form_Load Event to appear in either an
unbound textbox, or a label, where you set "Labelabc.Caption = M"...where M
is a string that you calculate from your code above.

HTH - Bob
 
Top