访问摘要报告 [英] Access Summary Report
问题描述
我有一张包含年龄,城镇,性别等信息的表格。我希望查看类似的报告:
性别
男性 30
女性 20
年龄
1到4 10
5到10 10
11到19 17
20到29 22
30到39 23
结束39 30
我现在正在做的方法是添加一个文本框并为每个参数使用dcount函数。男性的dcount,女性的dcount,1到4岁的dcount等等。是否有更简单的方法来制作这样的摘要报告?
Hi, I have a table with information such as age, town, sex etc. I wish to view a report something like this:
Sex
Male 30
Female 20
Age
1 to 4 10
5 to 10 10
11 to 19 17
20 to 29 22
30 to 39 23
over 39 30
The way I am doing it right now is adding a text box and using the dcount function for each parameter. A dcount for male, dcount for female, dcount for age 1 to 4 etc.. Is there an easier way to make a summary report like this?
推荐答案
创建一个查询,为每条记录显示您要显示的所有信息:
Create a query that indicates, for each record, all the information you want to show :
- [Sex]。
- [年龄]。
在详细信息部分创建一个包含此信息的报告,但隐藏详细信息部分。
创建报告页脚部分,根据需要汇总数据。
Create a report that has this information in the Detail section, but make the detail section hidden.
Create a Report Footer section that summarises the data as you need.
非常感谢NeoPa!我的总结看起来很棒!
Thanks a lot NeoPa! My summary looks great!
对你有好处:-)
我很高兴能指出你正确的方向。
Good for you :-)
I''m glad that was able to point you in the right direction.
这篇关于访问摘要报告的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!