You will need to create two grouped queries one for current year other from previous year where data is grouped and summed by month.
You can then create a new queries by linking the two queries by month field.
On 3 Jan 2015 05:30, "statmanbp@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:
Thank you for the quick answer. Since I am on the subject of previous months can you guide me in the direction to create report to show previous years comparison by month.
__._,_.___
Posted by: Rajiv <torajiv@gmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (4) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar