Need to create a report that tallies the "yes" answers in a column

[bradp1979]

.



And I am confused. Why does the Count() expression show "Yes" and not a number?

I just copied what you had in the MVR field in post 23

[bradp1979]

The error message in the text box:

[June7]

That is because the textbox has same name as the field referenced in the expression. Change the textbox name to something like: tbxMVR.

[bradp1979]

Done, and the error went away.

However, when I go back to report view, I'm still seeing the same thing I showed in the image in post 42. It's showing "Yes" for everyone, even though none of them have a "yes" in the MVR column of tblRelEventEmployee. For each of them, it should show a 0. There is only one employee that I have selected as MVR so that I could test the report, so he should be the only one with any "1"s.

[June7]

Make sure the Format property of the textbox does not say Yes/No.

[bradp1979]

Ok, now we're getting somewhere. Now the MVR column does have a count, but none of them are 0... It seems to be counting the number of shifts worked as opposed to the number of times selected as MVR.

[June7]

Sorry, try Sum instead of Count in the textbox expression.

Also, need to change the SQL statement to pull EmployeeID from tblEmployees and bind textbox to that field. And fix the EmployeeID header grouping field.

[bradp1979]

Ok, it's been a while since I tackled this issue, but now I've got it looking exactly how I want (shown below). The next issue to tackle (pulling the report using a date parameter) will be in a new post.