我以为很复杂,结果用分组统计就出来了,好牛的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")
[此贴子已经被作者于2014-2-21 17:32:07编辑过]