hi guys,
its my first post and I am really hoping that you will solve my problem,
we make Sales reports for a company, where we have to report MAT(moving annual total)ie. sum of the last 12 months sales, and we also report YTD(year to date)i.e. sum of the sales starting from jan to the present month.we normally have data for 3 to 4 years.
Now the problem I can easily calculate this in excel and make it dynamic by stretching the formulae,but is there any way I can make it dynamic in Access.
Thanks in advance.
its my first post and I am really hoping that you will solve my problem,
we make Sales reports for a company, where we have to report MAT(moving annual total)ie. sum of the last 12 months sales, and we also report YTD(year to date)i.e. sum of the sales starting from jan to the present month.we normally have data for 3 to 4 years.
Now the problem I can easily calculate this in excel and make it dynamic by stretching the formulae,but is there any way I can make it dynamic in Access.
Thanks in advance.