I hope the title makes sense. I need to know how to subtract the value of one row and column from another.
I have a Access db with a table listing of employee holiday entitlement. A record of how many days holidays taken is kept in another table. The two tables are related by employee ID. How can I subtract the number of holidays taken way from an employees holiday entitlement so as to give me a running total of holiday entitlement the employee has left?
I have a Access db with a table listing of employee holiday entitlement. A record of how many days holidays taken is kept in another table. The two tables are related by employee ID. How can I subtract the number of holidays taken way from an employees holiday entitlement so as to give me a running total of holiday entitlement the employee has left?