Hello.



Not sure if I can explain this well, but here we go.
I think the picture attached might help to explain.

I have a database which looks at elements within a property i.e kitchen and when the kitchen is to be replaced.

The query looks at the kitchen type and the renew year then the relationship to the cost table looks up the type and places the cost in which Renew Year has been selected.

However these need to be 30 year cost profiles (i.e Range from Current Date to 30 years on 2011-2031) and a Kitchen has a 15 year life cycle. Therefore for a 30 year plan it should show some costs twice.

I.e if a kitchen is due for replacement in year 2012 I need the cost to be added to the costs in year 2027.

Is there anyway to build into the query or report to do this?

Any help much appreciated.