[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

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 4
• New Files 2

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___