473,387 Members | 1,619 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Year Formatting April-March

The Yearly Queries in Access consider the Calender Year from January to December, but in India we are using Financial year from April to March. Is it possible to make it that way? How?
Sep 22 '07 #1
1 2745
FishVal
2,653 Expert 2GB
The Yearly Queries in Access consider the Calender Year from January to December, but in India we are using Financial year from April to March. Is it possible to make it that way? How?
Hi, there.

Yes it is possible.
Compare these two queries:
first one for Jan-Dec year
Expand|Select|Wrap|Line Numbers
  1. SELECT * FROM tblTable WHERE Year([dteDate])=[Your year input];
  2.  
second one for Mar-Apr year
Expand|Select|Wrap|Line Numbers
  1. SELECT * FROM tblTable WHERE Year(DateAdd("m", -3, [dteDate]))=[Your year input];
  2.  
Regards,
Fish
Sep 23 '07 #2

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

Similar topics

3
by: Yannick Turgeon | last post by:
Hello all, One of our PHP program bugged recently. I've reduced the problem to this: April 4th! Anybody can tell me if I'm doing something wrong? Why April 4th is not printing but replaced by...
1
by: James Bell | last post by:
After installing VS .NET 2002, I insert the MSDN Library April 2002 CD 1. After answering all of the questions, but just before installation begins, I get the following message box: Title:...
16
by: Douglas | last post by:
Gday, How would I format a number so that: TheValue = 32500 Displays in the TextBox as: $32,500.00
1
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...
3
by: ethoemmes | last post by:
Hi Does anyone know of a function I can use to return the current tax year. Our tax year runs from 6 April. I need a function which will return the tax year for a given date. TIA
6
by: Jean | last post by:
Hi, I am using an Access 2000 front-end to an Oracle 9 backend. I want to write a query that returns all records that are not older than one year for Column "Status_30" (which is a Date). ...
248
by: Generic Usenet Account | last post by:
As per Google's Usenet archives http://groups.google.com/googlegroups/archive_announce_20.html], the first discussion of the Y2K problem on the Usenet was on January 18 1985...
9
by: rjfjohnson | last post by:
Hey, Today is Thursday 16-Feb-06. The same thursday last year is 17-Feb-05. Because I am comparing daily sales between years, I need to know the date of the same weekdayname as last year, so...
2
by: joe | last post by:
how to get the day if 1-9 then 01-09 else 11-31 month if 1-9 then 01-09 else 10-12 year 01-99
3
by: jamesDA | last post by:
I have written a simple membership database which prints cards using a report with an expiry date on. The expiry date should be the Date Issued field plus one year and one week. I can add 53 weeks...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
1
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...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
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,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.