Counting in

[tngirl]

I am creating a Report and need to count the values for the FinalScoreID. I added the FinalScoreID field from the field list for the report. Value 1 = Yes and Value 2 = No. I need a count for each yes and each no. I thought this is what I needed in the Control Source for the field on the report for the query, but it is not working. Any help you can give is greatly appreciated.

=Count([FinalScoreID])=1


=Count([FinalScoreID])=2

[pbaldy]

This type of thing:

=Sum(IIf([FinalScoreID]=2, 1, 0))

[tngirl]

I am creating a Report and need to count the values for the FinalScoreID. I added the FinalScoreID field from the field list for the report. Value 1 = Yes and Value 2 = No. I need a count for each yes and each no. I thought this is what I needed in the Control Source for the field on the report for the query, but it is not working. Any help you can give is greatly appreciated.

=Count([FinalScoreID])=1
=Count([FinalScoreID])=2

When I use =Sum(IIf([FinalScoreID]=2, 1, 0)), I get an error saying Circular Reference. I was wondering, would I use this same format if I was using the text work rather than the code, I tried this but it would not work either. I thought this would be so easy but I'm finding it is not. Any help you can provide is greatly appreciated. Thank you so much.

=Sum(IIf([FinalScoreID]=Yes, 1, 0)),

[ssanfu]

need to count the values for the FinalScoreID

What does this mean? That the game is over and the scores a final? What values are allowed? Examples of data?



You might try:
=Count([FinalScoreID] = 1)
=Count([FinalScoreID] = 2)

Note the end parenthesis position

[pbaldy]

Make sure a textbox doesn't have the same name as the field.

[tngirl]

Thanks so much, it is working

[pbaldy]

One of us was happy to help.

You might clarify for future users what you were able to get working.

[ssanfu]

Another was happy to help, also. (if I did)