按年龄分组数据 [英] grouping data by age
问题描述
嗨
我无法理解如何进行群体年龄
我有一个查询表，其中包含我需要的信息，即年龄字段我想要做的是按年龄组分组，例如19岁以下，20到29岁，30到39岁等。
然后我需要将此信息放入交叉表查询中以进行计数
我曾尝试过几种方式，但我不知道为什么我没有获胜
我将不胜感激任何帮助。
如果有帮助，请准确说明我输入信息的位置，因为我认为这是我出错的地方。
Hi
I am having trouble getting my head around how to go about group ages
I have a querytable which holds the information that I need that is the age field What I want to do is group this by ages groups eg under 19, 20 to 29, 30 to 39 etc.
I then need to put this information into a crosstab query to do the count
I have tried to do this several ways but am at a loss as to why I am not winning
I would appreciate any help that you can give.
If helping please state exactly where I enter the information as I think this is where I am going wrong.
推荐答案
实现这一目标的多种方式，但最灵活的是用[AgeFrom]和[AgeTo]和[AgeGroup]创建一个表。
使用查询中的这些字段与原始表一起加入[Age]，如：
Multiple ways of achieving this, but the most flexible is to create a table with [AgeFrom] and [AgeTo] and [AgeGroup].
Use these fields in the query to join with the original table with [Age] like:
是否可以将表达式或函数放入其中在excel中你可以分组而不制作新表我会更喜欢有一个函数或类似的东西
is there away to put an expression or function in that will group even in excel you can group with out making new tables I would perfer to have a function or something like
按下E键。 （Sigma）查找按钮以创建一个Group By查询总计字段。 Access将在查询设计模式中添加一行，用于聚合函数，如Sum，Count，Max等。
如果以前没有使用过，请检查Group By查询的帮助文件。 br />
Nic; o）
Press the "E" (Sigma) looking button to create a Group By query for totalling field(s). Access will add in query design mode a row for the aggregation functions like Sum, Count, Max, etc.
Also check the help file for the Group By queries when you haven′t used them before.
Nic;o)
这篇关于按年龄分组数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
