问题描述
我对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)
感谢您的想法。
假设[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.
这篇关于记录具有特定记录的计数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！