要根据buynsell表中的统计数据填满外管报表,包括本月发生及本年累计。
外管报表中:
J100=dsum(金额,"buynsell",外管分类 like "J1*")
J101=dsum(金额,"buynsell",外管分类 like "J101*")
J10101=dsum(金额,"buynsell",外管分类 like "J10101*")
……
S200=dsum(金额,"buynsell",外管分类 like "S2*")
S201=dsum(金额,"buynsell",外管分类 like "S201*")
J20101=dsum(金额,"buynsell",外管分类 like "S20101*")
……
其它类推
现在的问题是有什么简便的方法做出外管报表吗?用分组查询好象做不到。
先谢谢各位大侠了。 文件下载