报表-组中的运行计数 [英] Report - Running Count within a Group
问题描述
我有一个按RoomType_ID分组的Access 2007报告
I have an Access 2007 report which is grouped by RoomType_ID
我需要对组中的每一行进行连续计数,以便最终得到类似的结果:
I need to do a running count on each line within the Group so that I end up with something like:
RoomType_ID 1 1史密斯夫妇 2琼斯夫妇 3史密斯夫妇
RoomType_ID 1 1 Mr and Mrs Smith 2 Mr and Mrs Jones 3 Mr and Mrs Smythe
RoomType_ID 2 1傅先生 2巴太太
RoomType_ID 2 1 Mr Foo 2 Mrs Bar
等...
我怎样才能得到这个?
推荐答案
只需在报告的详细信息部分中放置一个文本框,使该文本框的数据源简单即可:
Just place a text box in the details section of the report, make the data source of the text box simply:
=(1)
在上述文本框的数据标签上,将运行总和设置为全部"
On the data tab of the above text box, set the running sum = "over all"
因此,您在报表中有一行详细信息:
So, you have For one line of detail in the report:
[=(1)] [Couples Name] [Phone Number] ..etc
然后,我将文本框称为"textCount"
And, I would call the text box "textCount"
并且,如果您想在报告的结尾",可以通过将以上文本名称放在报告FOOTER中的另一个文本框中来显示最终计数. 例如: [textCount]
And, if you want at the "end" of the report, you can show a final count by placing the above text name in another text box in the reports FOOTER. eg: [textCount]
将运行总和设置为否.
这篇关于报表-组中的运行计数的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!