Microsoft Access-总计将多个字段加在一起 [英] Microsoft Access - grand total adding multiple fields together

问题描述

我不太清楚这一点. 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-总计将多个字段加在一起的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！