melinhomes
asked on
Access query/report - calculate difference between two totals, that are grouped.
I have a query whereby there are values for printing, for example:
Business Unit: IT
June 2015 £150
June 2016 £50
Business Unit: Finance
June 2015 £200
June 2016 £100
In my report I want to show the difference (saving) between the two years for each business unit. See attached document for query screenshot and report, with details of grouping etc.
Doc2.docx
Business Unit: IT
June 2015 £150
June 2016 £50
Business Unit: Finance
June 2015 £200
June 2016 £100
In my report I want to show the difference (saving) between the two years for each business unit. See attached document for query screenshot and report, with details of grouping etc.
Doc2.docx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If there actually were fields named AccessTotalJune2016 and AccessTotalJune2015, that would be a seriously poor table design. The data is more likely in the same column but in different rows. That means that the on Format event would need to be used to save one value and use it for the calculation on the next row but without some knowledge of the report and table structure, I can't provide exact instructions.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
good options provided