How to Sum CheckBox in Query as a Positive #

[mopester]

This is prob so easy, that I couldn't find the answer. I need a Query to search specific checkbox fields and give me the total selected. When I use the Sum in the Query design, I get the results as a negative number. How do I change it to a positive #?

 

[dhookom]

Use Abs([CheckBoxField])

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[mopester]

Where should I put Abs([CheckBoxField]) ?

 

[dhookom]

Abs() converts all numbers to positive. To count the number of checked boxes, use:
=Sum(Abs([CheckBoxField]))
In any Group or Report Footer or Header section.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[mopester]

I'm sorry, I thought I had a little understanding of how to do this, but obviously I don't. I've spent an hour trying to get this to work. I thank you for your help. If you want to spell this out for me, I'd appreciate it. If not, I understand.

 

[dhookom]

If your Yes/No field name is FieldA and you want your query to count the number of Yes values then create a calculated column in you query:
Field: FieldAYes: Abs(FieldA)
Total: Sum

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[mopester]

Got it!! Thanks!!!