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!
4 1821
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
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...
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
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
Sign in to post your reply or Sign up for a free account.
Similar topics
by: MissiMaths |
last post by:
This isn't really an access question as I can write the code myself(I
hope) but need to know how the start of the financial year is worked
out. If someone knows the rules or an algorithm, I would...
|
by: haydn_llewellyn |
last post by:
Hi,
My company runs on a fiscal calendar that starts on the first monday in
July, and is based on a 13 week quarter (4 weeks, 4 weeks, 5 weeks).
What I need, is a way of relating Date() to the...
|
by: JohnC |
last post by:
This fantastic expression was posted by Duane Hookom. I have no idea how it
works but it displays the fiscal year and quarter for FY starting on October
1.
=Format$(DateAdd("q",1,),"\Qq...
|
by: rkohon |
last post by:
Hello all,
I am new to JavaScript and need some ideas, suggestions, or code snippets.
I have a form which requires the end user to put in a date for required items. I need javascript function to...
|
by: Twobridge |
last post by:
Hi
I am trying to perform a search that will return records based on a
fiscal year search of the bill_Date. The user gives the year then I
want to search based on the fiscal year (July 1 - June...
|
by: shiznaw |
last post by:
I got another problem while working on this database for the Univ.
The Form.viewreports has several radial button options so that the user can
view a Report for several periods--like a day, a...
|
by: uzairahm |
last post by:
Hi!
I wanted to modify the query the query is given below.
SELECT Format(,"yyyy") AS , ProcFees.ProcName, Count(ProcFees.ProcName) AS CountOfProcName
FROM ProcFees INNER JOIN (Procedures INNER...
|
by: craigfr |
last post by:
I am making a graph comparing last year's defect data with YTD defect data. Our fiscal year starts Nov.1 and ends Oct.31.
To get the YTD, I started used a simple date serial criteria:
Between...
|
by: RZ15 |
last post by:
Hi guys,
I'm really drawing a blank here for how to deal with fiscal months in my monthly sales/receipts reports. My issue is that calculating the months is not as simple as saying 'if the invoice...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |