I need to add up the total days of sick leave, as well as the total vacation leave. This way I can track if they have reached the maximum # of leaves. Can someone assist me?
Solved
Summing rows with condition
+4Best answer by Databaser
As I understand it, you "leave" records are linked to Staff. In that case, you can use a rollup field in the Staff table to add up every "leave count".
+25As I understand it, you "leave" records are linked to Staff. In that case, you can use a rollup field in the Staff table to add up every "leave count".
+4As I understand it, you "leave" records are linked to Staff. In that case, you can use a rollup field in the Staff table to add up every "leave count".
Thanks a bunch!!
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.