How do I compare receipts for the same month in different years in Microsoft access
Posted on 2014-10-04
I have a table with three fields post_prd, post_yr, and Receipts. I would like a report that compares the receipts for each post_prd against the Receipts for the previous post_prd showing the variance between the two post_prd's both in dollars and percentage so that one column shows year 1 second column shows year two and third column shows variance in dollars fourth column shows variance in percentage. At the bottom of each column, I would like a total for each year. I would like it to be presented in landscape spreadsheet format. I would like to do this with a Microsoft Access report. Any help would be appreciated.