financial year query (1 Viewer)

jai kushwaha

Registered User.
Local time
Tomorrow, 01:11
Joined
Nov 1, 2015
Messages
61
Hello friends, how are you?? I need a help I am making a database and have a column named date. Now using this column i want to make a querry which ask me for starting financial year and and when i type 2015 it will give me all relevant info between 1/4/15 to 31/3/16.

I need help.. ...
 

Minty

AWF VIP
Local time
Today, 19:41
Joined
Jul 26, 2013
Messages
10,355
Firstly please change your field name from date - it is a reserved word and will cause you lots of problems. See here : http://allenbrowne.com/AppIssueBadWord.html

Secondly - Are your financial years fixed from 1/4/ through to 31/3 the next year. If so then try the following in your criteria of your date field (NOT called date :) )assuming your parameter is called [EnterDate];

Between Cdate("01/04/" & [EnterDate]) AND CDate("31/03/" & VAL([EnterDate] + 1))
 

jai kushwaha

Registered User.
Local time
Tomorrow, 01:11
Joined
Nov 1, 2015
Messages
61
Thanks for reply will it ask for which financial year and if I will type 2015 will it give me all info from 1/4/15 To 31/3/16?? ??
 

Users who are viewing this thread

Top Bottom