Those dates are absolute. Your calendar year will always be 04/01 - 03/31
Why can't you hard code the start date in your "YTD" function as
04/01/[current year] to CurrentDate?
You have to do something like "SELECT * FROM YTD WHERE Date <= CURRENTDATE
AND DATE >= 04/01/2011" to get the values
Thanks
Andy
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of access_kri
Sent: Thursday, May 26, 2011 1:34 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Financial Year and YTD calculation
Hi,
Our financial year starts from 1st April to 31 March. I have a plant
performance table with figures for daily production, running hours, downtime
etc. We have to report the YTD (year till date) figures starting from 1st
April. Week1 would start from April 1 to April 7 etc.
I have totals query to calculate the totals but it gives the total starting
from calendar year. How can I get all the totals financial year and compare
with budgeted figures? Do I have to create a function? Please help. Thanks
Best Regards,
Kumar
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar