Hello.
I have a report which shows a 30 year forecast budget.
It is based on showing the first 5 years indivual then in 5 year increments.
These figure are based on life cycles of component. I.e. 20years for a kitchen. Therefore if a kitchen cost is in year 2015 it also needs to be in year 2035 (Year 26-30 group)
The picture attached might help to aid this issue.
What I need is to be able to add certain groups together.
I have tried using the control source for the text box and using the builder to say =[Year 1-6]+[Year 26-30] but this gives blank.
Any help much appreciated.
Thanks
I have a report which shows a 30 year forecast budget.
It is based on showing the first 5 years indivual then in 5 year increments.
These figure are based on life cycles of component. I.e. 20years for a kitchen. Therefore if a kitchen cost is in year 2015 it also needs to be in year 2035 (Year 26-30 group)
The picture attached might help to aid this issue.
What I need is to be able to add certain groups together.
I have tried using the control source for the text box and using the builder to say =[Year 1-6]+[Year 26-30] but this gives blank.
Any help much appreciated.
Thanks
