我有一个按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]
将运行总和设置为否.
更多推荐
报表
发布评论