Count "Yes" in a query

[julessantana]

I need a query that will return positive values to count how many "Yes" in a column. It's a checkbox. I have the query set up to "group by" the project. I used the "Sum" function in the query, and it's giving me negative answers, because "Yes" is stored as -1.

Where/how do I change this so the results of the query will be positive, rather than negative?



Thank you!

[ItsMe]

Edit: rather than sum maybe you need Count.

[June7]

Or

Sum(Abs([fieldname]))

Or

Sum([fieldname]*-1)

[julessantana]

Where does the expression go in the query design?

[June7]

Only use in query if the query is a GROUP BY (Totals) aggregate query.

In the Field row enter: Abs([fieldname]) or [fieldname] * -1 and select Sum from the Total row. Of course, use your actual field name.

Otherwise, use in textbox in group or report header/footer section.

If you want to display raw data detail records as well as aggregate calcs, don't use a GROUP BY query as report RecordSource.