Formatting Counts

[Jahmbone]

When I count check boxes for a specified condition how do I get them to count
in positive values opposed to the negative values

 

[Al Campagna]

Jahmbone,
= ABS(Chk1 + Chk2 + Chk3......)
or
= (Chk1 + Chk2 + Chk3......) * -1
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."