hi
i have a query to calculate the monthly depreciation for a machine for specific period of time.
my problem is how to get the number of months for each period assuming i want to start from month September 2009 till may 2012.
attached the data extracted by the query.
i want to calculate the depreciation to be grouped year by year in report.
regards
dmc
[TR]
[TD][TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]