Report creating in Access by Grouping

[saleemsadique]

Hello All,
I need to create a Group Report and subtract values from a field between two different years

example value for Jan 2013 subtracted from Value of Jan 2014 i have attached database and the PDF file how I need output.

Please help me to achieve this result.

thank you in advance

Regards,
Saleem

[June7]

Having a record pull value from another record in same dataset is not easy in query. Requires nested subquery or domain aggregate function. Review: http://allenbrowne.com/subquery-01.html#AnotherRecord

However, textbox on report has a RunningSum property that might accomplish what you want. Nope, just tested.

Will this report always have only 2 years data?

Instead build groups in report for jobno and PUB_apsv_name.

Expression in textbox in PUB_apsv_name footer:

=Sum([Jan]*IIf([Year]=2013,-1,1))

Problem with this is will have to modify the report every year to change every textbox expression. Have a form with unbound control for entry of the first year. Textbox named tbxYear in report header can reference the form:

=[Forms]![formname]![controlname]

Then the report expression:

=Sum([Jan]*IIf([Year]=[tbxYear],-1,1))

Ooops, that expression is not working. Access doesn't find tbxYear. Odd. Thought sure done this before.

[saleemsadique]

Thanks lot... my issue related to subtracting value of 2013 from 2014 resolved with your expression =Sum([Jan]*IIf([Year]=2013,-1,1))
Now I could not figure out how to get the percentage of subtracted value divided by value of 2013 multiply by 100
example from my report image last total column last record 444/1175*100 =38%
444 is the subtracted value 1175 value of year 2013
Please help me on this...

Thanks in Advance

[June7]

Name the textbox with difference calc like tbxDiff.

Try:

=[tbxDiff]/Sum(IIf([Year]=2013,[Jan],0))*100

[saleemsadique]

Thanks @ june7

My issue resolved by solution you provided. Million Thanks