By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,504 Members | 1,584 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,504 IT Pros & Developers. It's quick & easy.

Fiscal Year

P: 7
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!
Jun 1 '07 #1
Share this Question
Share on Google+
4 Replies


P: 7
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_AfterUpdate()
yearit
dateit
End Sub
Private Sub Text33_AfterUpdate()
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
Jun 1 '07 #2

P: 7
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...
Jun 1 '07 #3

P: 11
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
Jun 27 '07 #4

FishVal
Expert 2.5K+
P: 2,653
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
Jun 27 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.