关于交叉表联合查询中的日期变成了文本，无法排序

试试：

TRANSFORM Sum(t.数据) AS 数据OfSum
SELECT format(t.日期,"yyyy/mm/dd"), Sum(t.数据) AS 合计
FROM (select 日期,"",小组,数据
    from 记录表
    union all
    select '共计' as 日期,null as "",小组,sum(数据) 
    from 记录表
    group by 小组)  AS t
GROUP BY format(t.日期,"yyyy/mm/dd")

PIVOT t.小组;