Calculating checkboxes

[Guest]

When I try to get a total number of boxes that are checked off for a certain
category I get a negative number.

This is the formula I used in the Control Source:
Sum=([Recordable])

What am I doing wrong??

 

[Duane Hookom]

That's why Fredg suggested wrapping the Sum() inside Abs()
=Abs(Sum([Recordable]))

 

[Guest]

You are a genious. I've been trying to figure this out all day. Thank you
sooo much.

That's why Fredg suggested wrapping the Sum() inside Abs()
=Abs(Sum([Recordable]))

--
Duane Hookom
MS Access MVP

When I try to get a total number of boxes that are checked off for a
certain
category I get a negative number.

This is the formula I used in the Control Source:
Sum=([Recordable])

What am I doing wrong??

 

[fredg]

You are a genious. I've been trying to figure this out all day. Thank you
sooo much.

That's why Fredg suggested wrapping the Sum() inside Abs()
=Abs(Sum([Recordable]))

--
Duane Hookom
MS Access MVP

When I try to get a total number of boxes that are checked off for a
certain
category I get a negative number.

This is the formula I used in the Control Source:
Sum=([Recordable])

What am I doing wrong??

How come Duane gets the credit when i did all the work? <g>

 

[Guest]

I'm sorry, your a genious as well!! I really appreciated the quick response
from both of you, I was about ready to pull out my hair.

You are a genious. I've been trying to figure this out all day. Thank you
sooo much.

That's why Fredg suggested wrapping the Sum() inside Abs()
=Abs(Sum([Recordable]))

--
Duane Hookom
MS Access MVP

When I try to get a total number of boxes that are checked off for a
certain
category I get a negative number.

This is the formula I used in the Control Source:
Sum=([Recordable])

What am I doing wrong??

How come Duane gets the credit when i did all the work? <g>

 

[Duane Hookom]

;-)

--
Duane Hookom
MS Access MVP

You are a genious. I've been trying to figure this out all day. Thank you
sooo much.

That's why Fredg suggested wrapping the Sum() inside Abs()
=Abs(Sum([Recordable]))

--
Duane Hookom
MS Access MVP

When I try to get a total number of boxes that are checked off for a
certain
category I get a negative number.

This is the formula I used in the Control Source:
Sum=([Recordable])

What am I doing wrong??

How come Duane gets the credit when i did all the work? <g>

 

[fredg]

I'm sorry, your a genious as well!! I really appreciated the quick response
from both of you, I was about ready to pull out my hair.

You are a genious. I've been trying to figure this out all day. Thank you
sooo much.

:

That's why Fredg suggested wrapping the Sum() inside Abs()
=Abs(Sum([Recordable]))

--
Duane Hookom
MS Access MVP

When I try to get a total number of boxes that are checked off for a
certain
category I get a negative number.

This is the formula I used in the Control Source:
Sum=([Recordable])

What am I doing wrong??

How come Duane gets the credit when i did all the work? <g>

No problem. I was just havin' some fun.
Happy to help.