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

Gary Kjos garykjos at hotmail.com
Fri Jan 16 12:53:25 CST 2004


To each their own. More than one way to skin a fish. Six of one, half dozen 
of the other. ;-)

No you don't need to reverse the sign, but if you are just printing or 
e-mailing the query results as I mostly do, it is a easy way to get it 
looking right.


Gary Kjos
garykjos at hotmail.com





>From: "Charlotte Foust" <cfoust at infostatsystems.com>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: "Access Developers discussion and problem 
>solving"<accessd at databaseadvisors.com>
>Subject: RE: [AccessD] I need a count of checkboxes in a report
>Date: Fri, 16 Jan 2004 10:16:50 -0800
>
>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
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com

_________________________________________________________________
High-speed users—be more efficient online with the new MSN Premium Internet 
Software. http://join.msn.com/?pgmarket=en-us&page=byoa/prem&ST=1



More information about the AccessD mailing list