Dear all,
I need your help with certain fields I have with my access database which I am struggling with. Firstly, I have to say I only learnt this over the last two months so apologies if I come across as a borderline novice to you. I would like my first term fees, 2nd term fees and third term fees to change based on what financial year I and Year/Class I choose. For example, if Financial year is 2019/2020 and I select Pre-Nursery, then 1st term fees would differ based on these values. Please find screenshot of what I am trying to work on. Certain fields are calculated fields such as Outstanding and total paid sections. Can anyone recommend an event under properties or a process to get this work as planned. I have screenshots of the table and the actual form on access. The reason for this is because different Year/Classes have different fees and fees change during different financial years. I am as basic as it comes or less when it comes to access, so please bare this in mind.
I need your help with certain fields I have with my access database which I am struggling with. Firstly, I have to say I only learnt this over the last two months so apologies if I come across as a borderline novice to you. I would like my first term fees, 2nd term fees and third term fees to change based on what financial year I and Year/Class I choose. For example, if Financial year is 2019/2020 and I select Pre-Nursery, then 1st term fees would differ based on these values. Please find screenshot of what I am trying to work on. Certain fields are calculated fields such as Outstanding and total paid sections. Can anyone recommend an event under properties or a process to get this work as planned. I have screenshots of the table and the actual form on access. The reason for this is because different Year/Classes have different fees and fees change during different financial years. I am as basic as it comes or less when it comes to access, so please bare this in mind.