Could someone please help me to solve this query? How can I create a query that’s enabled me to check leave balance of each/ all type of leave al & el (same leave category), mc & cl at the end of every week/ month based on staff id? The Excel file is currently used for entering leave application & checking.

Thanks