Hi All,
Looking for some help, I am creating a database to project a budget for my company. So far I have a table which contains a list of properties and the year a kitchen, bathroom, boiler etc was installed. As well as a life cycle on those components, for example a bathroom installed in 2005 would be due for replacement 2019 as well as a budgeted cost.
I created a form to show each component in a TXTbox as per attachment. what I want the form to do, when i type in a year in the box, the kitchen, bathroom and so on pre-populate as per the year typed in the box to project the cost for that year, so if I type in 2019 it would show forecasted cost. In the same way you would use the sumif on excel. The data is saved on a table so the expression would look up the values from there.
Although when I tried using =Sum(IIf... it got an Error not sure what I have done wrong or if it is even possible.
Any help would greatly appreciated.
Looking for some help, I am creating a database to project a budget for my company. So far I have a table which contains a list of properties and the year a kitchen, bathroom, boiler etc was installed. As well as a life cycle on those components, for example a bathroom installed in 2005 would be due for replacement 2019 as well as a budgeted cost.
I created a form to show each component in a TXTbox as per attachment. what I want the form to do, when i type in a year in the box, the kitchen, bathroom and so on pre-populate as per the year typed in the box to project the cost for that year, so if I type in 2019 it would show forecasted cost. In the same way you would use the sumif on excel. The data is saved on a table so the expression would look up the values from there.
Although when I tried using =Sum(IIf... it got an Error not sure what I have done wrong or if it is even possible.
Any help would greatly appreciated.