如何进行人事汇总查询报表？如图

1、先写一个查询1：
SELECT format(入职时间,"yyyymm") as 年月,count("*") as 本月入职,count("*") as 本月离职
FROM 原始数据表
GROUP BY format(入职时间,"yyyymm");

2、再写一个查询2
select *，dsum("本月入职-本月离职","查询1","年月<'" & [年月] & "'") as 月初人数，dsum("本月入职-本月离职","查询1","年月<='" & [年月] & "'") as 月末人数
from 查询1;