我以为很复杂,结果用分组统计就出来了,好牛的foxtable:
Dim g As New GroupTableBuilder("统计表1", DataTables("表A"))g.Groups.AddDef("入职日期", DateGroupEnum.Year, "年")g.Totals.AddDef("入职日期", AggregateEnum.Count, "入职")g.Totals.AddDef("离职日期", AggregateEnum.Count, "离职")g.Build()MainTable = Tables("统计表1")