Fiscal Year

[ltazz]

How can i make it so that Access will Recognize the fiscal year 07 start at 1 oct 2006, and end 30 Sep 2007?
i know its possible, however cant figure it out.
Thanks for the help in advance you guys are great!

[ltazz]

Anyone know how to make this statement work???
Trying to have it subtract a year from the first 2 months of the FY, october, november, and december.
if i can get this to work i will have no issues...

Private Sub Command0_Click( )
Me.Text1 = "# " + Me.Text37 + "" + Me.Text39 + " #"
Me.Refresh

End Sub

Private Sub Text35_AfterUpd ate()
yearit
dateit
End Sub
Private Sub Text33_AfterUpd ate()
yearit
dateit
End Sub

Private Sub dateit()
If Me.Text33 = "OCT" Then Me.Text37 = "10/1/20"
If Me.Text33 = "NOV" Then Me.Text37 = "11/1/20"
If Me.Text33 = "DEC" Then Me.Text37 = "12/1/20"
If Me.Text33 = "JAN" Then Me.Text37 = "1/1/20"
If Me.Text33 = "FEB" Then Me.Text37 = "2/1/20"
If Me.Text33 = "MAR" Then Me.Text37 = "3/1/20"
End Sub

Private Sub yearit()
If Me.Text33 = "Oct" Then Me.Text39 = "" + Me.Text35 + ""
If Me.Text33 = "NOV" Then Me.Text39 = "" + Me.Text35 + ""
If Me.Text33 = "DEC" Then Me.Text39 = "" + Me.Text35 + ""
If Me.Text33 = "JAN" Then Me.Text39 = "" + Me.Text35 + ""
If Me.Text33 = "FEB" Then Me.Text39 = "" + Me.Text35 + ""
If Me.Text33 = "MAR" Then Me.Text39 = "" + Me.Text35 + ""
If Me.Text33 = "APR" Then Me.Text39 = "" + Me.Text35 + ""
If Me.Text33 = "MAY" Then Me.Text39 = "" + Me.Text35 + ""
If Me.Text33 = "JUN" Then Me.Text39 = "" + Me.Text35 + ""
If Me.Text33 = "JUL" Then Me.Text39 = "" + Me.Text35 + ""
If Me.Text33 = "AUG" Then Me.Text39 = "" + Me.Text35 + ""
If Me.Text33 = "SEP" Then Me.Text39 = "" + Me.Text35 + ""
End Sub

[ltazz]

once again i figured it out...
it may not be the cleanest, easiest way of doing it...
but it works.

thanks to any, and let me know if you need to know how i did it. ill be glad to give you a hand..
feel free to PM me...

[uzairahm]

once again i figured it out...
it may not be the cleanest, easiest way of doing it...
but it works.

thanks to any, and let me know if you need to know how i did it. ill be glad to give you a hand..
feel free to PM me...

Hi itazz
I am also looking for a solution for retrieving data as fiscal year (april- march)
could you please guide me the solution.
i have stored date in a date field type
thanks

[FishVal]

How can i make it so that Access will Recognize the fiscal year 07 start at 1 oct 2006, and end 30 Sep 2007?
i know its possible, however cant figure it out.
Thanks for the help in advance you guys are great!

Hi!


The simplest way I know is the following

Year(DateAdd("m ", -9, [Your Date]))
where 9 is a number of the last month in fiscal year (September in your case)

or the following which return a start of fiscal year [Your Date] belongs to
DateSerial(Year (DateAdd("m", -9, [Your Date])), 10, 1)


Good luck