Adding fields together in report

[GraemeG]

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

[GraemeG]

Resolved with Builder using:
Nz([Fieldname],0)+Nz([Fieldname2],0)

[RuralGuy]

Thanks for posting back with your success and solution.