计数条目 [英] Counting Entries
本文介绍了计数条目的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我有以下数据,时间约一千:
ID:1
名称:ABC
计数: 2
ID:2
姓名:ABC
点数:1
ID:3
名称:XYZ
数量:3
ID:4
名称: QRS
点数:1
ID:5
姓名:QRS
点数:1
我想要Access告诉我:
ABC总计3(2 + 1)
XYZ的总数为3
QRS的总数为2(1 + 1)
我该怎么做?我能做到吗?
任何帮助都会非常感激!
I have the following data, times about a thousand:
ID:1
Name: ABC
Count: 2
ID: 2
Name: ABC
Count: 1
ID:3
Name: XYZ
Count: 3
ID: 4
Name: QRS
Count: 1
ID:5
Name: QRS
Count: 1
I want Access to tell me:
ABC has a total count of 3 (2+1)
XYZ has a total count of 3
QRS has a total count of 2 (1+1)
how do i do that?? can I do that?
Any help would be greatfully appreciated!
推荐答案
我有以下数据,时间大约一千:
ID:1
名称:ABC
计数: 2
ID:2
姓名:ABC
点数:1
ID:3
名称:XYZ
数量:3
ID:4
名称: QRS
点数:1
ID:5
姓名:QRS
点数:1
我想要Access告诉我:
ABC总计3(2 + 1)
XYZ的总数为3
QRS的总数为2(1 + 1)
我该怎么做?我可以这样做吗?
任何帮助都将非常感谢!
I have the following data, times about a thousand:
ID:1
Name: ABC
Count: 2
ID: 2
Name: ABC
Count: 1
ID:3
Name: XYZ
Count: 3
ID: 4
Name: QRS
Count: 1
ID:5
Name: QRS
Count: 1
I want Access to tell me:
ABC has a total count of 3 (2+1)
XYZ has a total count of 3
QRS has a total count of 2 (1+1)
how do i do that?? can I do that?
Any help would be greatfully appreciated!
您将需要如下查询:
You will need a query as follows:
展开 | 选择 | 换行 | 行号
Cherry再次选择简单的Mary;)
BTW这是一个明确传达的问题的一个很好的例子。
我'' d祝贺OP,但他们是匿名的:S
Cherry-picking the simple ones again Mary ;)
BTW This is a good example of a clearly conveyed question.
I''d congratulate the OP but they''re anonymous :S
感谢您的祝贺,
不幸的是,我可能不那么先进这个,因此我真的不知道我输入的代码在哪里?它是通过查询设计视图吗?
,如果我想比较更多信息,它将如何工作,即:
ID: 1
名称:ABC
类型:0
数量:2
ID:2
名称:ABC
类型:1
数量:2
ID:3 >
姓名:ABC
类型:0
数量:2
ID:4
名称:XYZ
类型:1
数量:3
ID:4
名称:QRS
类型:0
数量:3
ID:5
名称:QRS
类型:1
数量:1
ID:6
名称:QRS
类型:1
数量:4
所以现在我想让Access告诉我:
>
ABC类型0总计数为4(2 + 2)
ABC类型1总计数为2
XYZ类型1总计数量3
QRS类型0总数为3
QRS类型1总数为5
再一次......我会感激任何帮助
thanks for the congratulations,
unfortunately, I may be less of a advanced at this, thus I really don''t know where I input that code? is it through the query design view?
also, how would it work if I wanted to compare more information, ie:
ID:1
Name: ABC
Type: 0
Count: 2
ID: 2
Name: ABC
Type: 1
Count: 2
ID: 3
Name: ABC
Type: 0
Count: 2
ID:4
Name: XYZ
Type: 1
Count: 3
ID: 4
Name: QRS
Type: 0
Count: 3
ID:5
Name: QRS
Type:1
Count: 1
ID: 6
Name: QRS
Type:1
Count: 4
So now I want Access to tell me:
ABC Type 0 has a total Count of 4 (2+2)
ABC Type 1 has a total Count of 2
XYZ Type 1 has a total Count of 3
QRS Type 0 has a total Count of 3
QRS Type 1 has a total Count of 5
once again...I''d appreciate any help
这篇关于计数条目的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文