[AccessD] I need a count of checkboxes in a report

You don't even need to do that.  Just use an Abs() function to return a
positive value.

Charlotte Foust

-----Original Message-----
From: Gary Kjos [mailto:garykjos at hotmail.com] 
Sent: Friday, January 16, 2004 10:00 AM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] I need a count of checkboxes in a report


In your totals query do a sum on the Yes/No field times -1 to reverse
the 
sign. ( -1 = Yes)

CancelledLineCount: Sum([CancelFlag]*-1)



Gary Kjos
garykjos at hotmail.com





>From: "John Clark" <John.Clark at niagaracounty.com>
>Reply-To: Access Developers discussion and problem
>solving<accessd at databaseadvisors.com>
>To: <accessd at databaseadvisors.com>
>Subject: [AccessD] I need a count of checkboxes in a report
>Date: Fri, 16 Jan 2004 12:12:25 -0500
>
>I'm trying to whip up a report for a client who uses one of my 
>programs. They are tracking the meal sites for the elderly and I have 
>provided a list, by site, with their client's names, age, gender, race,

>etc.. There are also six boolean fields that they track...for instance,

>"Low Income"...and I need to count the ones that are checked for each 
>site.
>
>I know this is easy, and I could have swore I've done it before, but I 
>cannot figure out how at this particular moment.
>
>John W Clark
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com 
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com

_________________________________________________________________
Find high-speed 'net deals - comparison-shop your local providers here. 
https://broadband.msn.com

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com