435,197 Members | 1,173 Online + Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,197 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
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

 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 