问题描述
我不太清楚这一点. Microsoft Access 2000，在报告总计"部分中，我有三列的总计，它们只是数字.这些=Sum[(ThisColumn1)], 2, 3等以及那些大型totl都可以正常工作.
I can't quite figure this out. Microsoft Access 2000, on the report total section I have totals for three columns that are just numbers. These =Sum[(ThisColumn1)], 2, 3, etc and those grand totls all work fine.
我想再写一列=Sum([ThisColumn1])+Sum([ThisColumn2]) + Sum([ThisColumn3])，但无法弄清楚.只是一片空白，所以我确定有一个错误.
I want to have another column that says =Sum([ThisColumn1])+Sum([ThisColumn2]) + Sum([ThisColumn3]) but can't figure those one out. Just get a blank so I am sure there is an error.
推荐答案
给出3个总计总计有意义的控件名称，然后供总计总计使用:
Give the 3 Grand Totals meaningful Control Names and then for the Grand Grand Total use:
=[GrandTotal1] + [GrandTotal2] + [GrandTotal3]
您的总计总数公式应类似于:
Your Grand Total formulas should be something like:
=Sum(Nz([ThisColumn1], 0))
这篇关于Microsoft Access-总计将多个字段加在一起的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！