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

Gary Kjos garykjos at hotmail.com
Fri Jan 16 13:03:40 CST 2004


Hmmmm. Works for me. Is your field a Yes/No data type?

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: RE: [AccessD] I need a count of checkboxes in a report
>Date: Fri, 16 Jan 2004 13:39:32 -0500
>
>how come it doesn't it let me do something like this right in the
>report? If I sum it or total it, I get a "Yes" or a "No".
>
> >>> cfoust at infostatsystems.com 01/16/04 01:16PM >>>
>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
>
>

_________________________________________________________________
Get a FREE online virus check for your PC here, from McAfee. 
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963



More information about the AccessD mailing list