Search results

Hi CJ, thanks for the reply, the code i used which may be wrong was =Sum(IIf([TblComponents]![Kitchen]="[YB]",[TblComponents]![Kitchen Cost],0)) YB relates to the name of the year box where the data would be entered, which I am trying to look up, as the year may change I wouldn't want to...

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...

Hey All, A little about myself, work in finance and have for some reason taken on the responsibility of building systems for the company. I am fairly new to Access, know my way around the system, all the basics creating forms, queries etc. everything else is a poke in the dark. Currently...