Hello Community,
I am new to this forum, so please forgive me if I am not putting this question in the correct sub forum. I am also relatively new to MS Access (I am working with the 2016 version). I am trying to create a bank ledger in Access 2016 - I have already created on in Excel, but I am trying to get better with Access and I thought this would be a good way to practice.
The problem that I am running into is that I have two fields - Credit and Debit - and when I enter a number into one of the fields I would like Access to either add or subtract that number and give me a total (See screenshots.) Is there a VBA code that I have to program into Access or is there a simpler way?