如何在Access 2007中获取组中的组计数 [英] How to get a count of a group within a group in Access 2007

问题描述

我有一个Access报告，我想这样输出:

I have an Access report that I would like to output like this :

Group 1 : Client : Cient Name - Contanct, etc
Group 2: WO : #WO - Date, etc. 

Detail : 
Item1
Item2
...
ItemN

End Group 2: Total for WO : Total, etc
End Group 1: Total for Client : Count(WO) and total

我无法正确获得Count(WO)部分.有什么办法可以做到?如果可以，怎么办?

I cannot get the Count(WO) part right. Is there any way to do this and if so how ?

大家都知道，如果我有一个客户端3 WO，该客户端总共15行，我希望Count(wo)为3，而不是15. 谢谢

Edit : Just so everyone understands, if I have 3 WO for one client and 15 lines total for the client, I want Count(wo) to be 3, not 15. thanks

推荐答案

您是否尝试过使用报告向导?它应该指导您创建此类报告.组页脚应有一个带有以下内容的文本框:

Have you tried using the report wizard? It should guide you through creating such a report. The group footer should have a textbox with:

=Count([WO])

编辑评论

在组标题中添加一个文本框，并将Running Sum属性设置为Over Group，将Visible属性设置为No，将Control Source设置为=1，将Name设置为GroupCount.在合适的页脚中，创建另一个文本框，然后将Control Source设置为=GroupCount.

Add a textbox to the group header and set the Running Sum property to Over Group, the Visible property to No, the Control Source to =1 and the Name to, say, GroupCount. In a suitable footer, create another textbox and set the Control Source to =GroupCount.

这篇关于如何在Access 2007中获取组中的组计数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！