[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