记录具有特定记录的计数 [英] record counts with specific records

问题描述

我对Access编程很生疏。我希望有一个人可以帮助我。我正在尝试在字段中包含特定记录数量的计数。该字段中记录的值为1,2,3或4.我似乎无法为报告提供正确的语句，该报告将为我提供记录数，例如，1为价值。

任何想法？

谢谢！

Hi,

I''m very rusty with Access programming. I hope someone can help me. I''m trying to include a count of the number of specific records in a field. Values for the records in the field are either 1, 2, 3, or 4. I just can''t seem to come up with the right statement for a report that will give me the number of records with, for example, 1 as the value.
Any ideas?
Thanks!

推荐答案

我对Access编程很生疏。我希望有一个人可以帮助我。我正在尝试在字段中包含特定记录数量的计数。该字段中记录的值为1,2,3或4.我似乎无法为报告提供正确的语句，该报告将为我提供记录数，例如，1为价值。

任何想法？

谢谢！

Hi,

I''m very rusty with Access programming. I hope someone can help me. I''m trying to include a count of the number of specific records in a field. Values for the records in the field are either 1, 2, 3, or 4. I just can''t seem to come up with the right statement for a report that will give me the number of records with, for example, 1 as the value.
Any ideas?
Thanks!

如果你将它分配给一个字段，


怎么样呢


= count（iif（[range1] = 1,1,0）

if you''re assigning it to a field,

how about something like

=count(iif([range1]=1,1,0)

如果你要分配它到一个领域，


怎么样呢


= count（iif（[range1] = 1,1,0）

if you''re assigning it to a field,

how about something like

=count(iif([range1]=1,1,0)

感谢您的想法。

假设[range1]是该字段的名称在表格中，当我使用它时，我得到一个输入参数的提示。我真正需要的是一个提供如下信息的表格：


记录整体表现= 1

记录总体性能= 2

记录总体性能= 3

记录总体性能= 4


整体效果数据全部存储在表格的一个字段中。

Hi,

Thanks for the idea.
Assuming [range1] is the name of the field in the table, when I use this, I get a prompt to enter parameters. What I really need is a form that provides info that looks like this:

# of records where Overall Performance = 1
# of records where Overall Performance = 2
# of records where Overall Performance =3
# of Records where Overall Performance =4

The Overall Performance data is all stored in one field in a table.

尝试在表格上放置文本框。文本框为


= DCount（*，TableName，[整体性能] = 1）

Try putting textboxes on the form. Set the textbox to

=DCount("*","TableName","[Overall Performance]=1")

这篇关于记录具有特定记录的计数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！